I want to chart the profit % and volume in XY plot. I would like to add the data labels

[Prakashnd75]

Hi
Attached sheet has Profit % and volume of sale I want plot in XY chart. I want to include data labels and quadrents too.

[teylyn]

Hello,

You can use the free XY Chart Labeler tool to add labels to a chart (not just XY Charts, either). The download is here: http://www.appspro.com/Utilities/ChartLabeler.htm

The tool activates the data labels and links them to the cells that have the text you want to show. You can also do that manually, but it is faster with the tool.

For quadrant lines, add two data series with the coordinates for X and Y with the desired values. and format these data series to show no markers and a line. For example, if you want quadrant lines at Y value 300 and X value 45%, add two series with these coordinates

Horizontal line

Please Login or Register  to view this content.

Vertical line

Please Login or Register  to view this content.

cheers, teylyn