Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Include info from data source in data table but not in chart | Charts and Charting in Excel | |||
Data labels other than charted values | Charts and Charting in Excel | |||
Pivot Table Col 1 & 2 to display info in rows | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Displaying symbols in charted data tables | Charts and Charting in Excel |