Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / May 2008

Tip: Looking for answers? Try searching our database.

Scatter Chart - Data Labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
les8 - 27 May 2008 17:16 GMT
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 - 27 May 2008 19:50 GMT
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

> Hi,
>
[quoted text clipped - 13 lines]
>
> Thank you.

Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.