"Don't dwell on what went wrong. Instead, focus on what to do next. Spend your energies on moving forward toward finding the answer."
-- Denis Waitley
Data Point Label
Labelling a single data point
By Neale Blackwood, 1 Feb 09
Did you know
that you can label a single data point on a Line chart?
This may be the highest, lowest or last data point on
the line. You may want to label it to highlight a specific
issue.
To get a label on a single point,
first click the point once, wait and then click it again.
Don't double click it, as that will bring up the options
for the line or all the data points rather than the single
point. Now right click the data point. Click Format data
point. Click the Data labels tab and select show value.
Click OK. If you need to add more labels repeat the clicking
twice process and then press F4 to repeat adding the label.
This technique will work for most other chart types. Just
click twice on the object involved (column, bar, pie segment)
before right clicking.
In Excel 2007 you click twice
on the data point to select it, then click the Layout
Ribbon tab and click the Data Labels button in the Labels
section and make your choice.
Stop zeroes displaying on line Charts - I have a line chart which has all the months of the year displayed. Each month is linked to a data cell. This means that future months display zero values. The line chart drops down to zero for these future months. Instead of having to change the chart range each month I want to stop the chart plotting the zero values for the future months. Is this possible?
You can use Excel's feature of not
plotting error values on charts to stop it displaying
the zero values ...
Print
