Results 1 to 4 of 4

Thread: Mark data points in Excel line chart

  1. #1
    Join Date
    Jun 2009
    Posts
    1,205

    Mark data points in Excel line chart

    I have created a small chart of company's progress in Excel. I want to mark certain data points in that chart where company's growth went high and low. But I don't know much about charts in Excel. How can I mark data points in Excel line chart ?

  2. #2
    Join Date
    May 2008
    Posts
    979

    Re: Mark data points in Excel line chart

    Excel includes some labels that you can use to mark data points. You can easily find under Format - Data points - Data labels. What you have to do is just add some X value to adjust the data points to your chart.

  3. #3
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Mark data points in Excel line chart

    You can even use some custom shapes as data points on your chart. For this use any handy symbol in Excel's extensive palette. Draw some shapes from the AutoShapes available on the Drawing toolbar on you worksheet. Resize, colour it and format it as you desire on your chart. Use Ctrl + V or Edit menu - Paste to paste your custom shape as your data point on your chart.

  4. #4
    Join Date
    Jan 2008
    Posts
    3,755

    Re: Mark data points in Excel line chart

    I want to add certain points to what has been suggested before and since you are new to Excel charts, it may be helpful to you. You can confirm in Excel help topic that the maximum number of data points that can be added for a data series in an Excel chart is 32000 for 2D charts and 4000 for 3D charts. And there can be 255 data series in a chart. So that comes to be 256000 data points in a whole in and Excel chart.

Similar Threads

  1. Setting Chart Data points with an array?
    By CodeKid in forum Software Development
    Replies: 2
    Last Post: 03-07-2012, 10:03 PM
  2. There is no data in Excel Pie Chart
    By Tarani in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 12:27 PM
  3. How to add straight line in a chart in Excel 2007
    By Nyota in forum MS Office Support
    Replies: 1
    Last Post: 25-02-2012, 12:06 PM
  4. Data points in Excel chart not lining up with axis
    By mbbackus in forum MS Office Support
    Replies: 1
    Last Post: 10-01-2012, 11:58 AM
  5. How to create alphanumeric data chart in Excel
    By Shaina Na in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 06:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,026,784.85353 seconds with 17 queries