Display Info in Data Table That is Not Charted?

K

Kevin

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!
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Overlay line graph points on bar graph 1
Creating a Chart on form from selected data in query. 0
Dates In Excel 5
Setting column width in a table with a macro is not working 0
Creating Network Diagram using a Chart SW integration 0
Data Labels, Error Bars, and Dynamic Charting 1
Help creating a search form in Access XP 0

Top