Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 504
Default Display Info in Data Table That is Not Charted?

Can anyone tell me if I can display information in the data table that is not
graphed in the chart? Then can I not show the data that is being graphed? I
have 10 lines of data, 4 are on the graph and I do not want them to be
included in the data table. The other 6 items are related but not graphed
and I have been asked to include them in the data table. Not sure this is
possible.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default Display Info in Data Table That is Not Charted?

Correct, this is not possible.

You could include all the series, and then format the unwanted series with
no fill/lines and no legend entry, but your data table would still have the
numbers for the series that you can see.

Note that you can insert a text box into a graph, and link it to a cell
(which might help you bring in the info you want). Simply create a text box,
type "=", and then click on the cell you want to link to.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kevin" wrote:

Can anyone tell me if I can display information in the data table that is not
graphed in the chart? Then can I not show the data that is being graphed? I
have 10 lines of data, 4 are on the graph and I do not want them to be
included in the data table. The other 6 items are related but not graphed
and I have been asked to include them in the data table. Not sure this is
possible.

Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Include info from data source in data table but not in chart UHSH Admin Charts and Charting in Excel 1 February 26th 09 05:04 AM
Data labels other than charted values Phil from Ohio Charts and Charting in Excel 1 December 29th 06 04:57 PM
Pivot Table Col 1 & 2 to display info in rows Johnny Excel Discussion (Misc queries) 2 November 23rd 06 01:57 PM
colors of bar charted data don't follow data after sorting Frankgjr Charts and Charting in Excel 2 January 17th 06 12:33 PM
Displaying symbols in charted data tables jageorge Charts and Charting in Excel 0 February 25th 05 07:03 PM


All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"