View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
les8 les8 is offline
external usenet poster
 
Posts: 10
Default Scatter Chart - Data Labels

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.