Hi,

I am new to charts and must create a chart where the data points are sales,
hours, and the store number. For example:
Store Hours Sales
1 200 100,000
2 300 200,000
3 350 350,000

I can create the scatter chart showing the intersection of the hours and
sales by selecting just that data, but cannot get the store number to appear
in the data label. When I select the store number as part of the data, that
gives me an incorrect data intersection. Is there any way to get the store
number as a data label without editing each data label? (I have over 3000
stores).

Thank you.

Hi,

Not something that is built in to charts. So instead try this free addin
which links data labels to cell.
http://www.appspro.com/Utilities/ChartLabeler.htm

Although with 3000 stores unless you are filtering that information in
some way the chart is just going to look crowded.

Cheers
Andy

les8 wrote:
Hi,

I am new to charts and must create a chart where the data points are sales,
hours, and the store number. For example:
Store Hours Sales
1 200 100,000
2 300 200,000
3 350 350,000

I can create the scatter chart showing the intersection of the hours and
sales by selecting just that data, but cannot get the store number to appear
in the data label. When I select the store number as part of the data, that
gives me an incorrect data intersection. Is there any way to get the store
number as a data label without editing each data label? (I have over 3000
stores).

Thank you.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info