Charts and data tables different info

  • Thread starter Thread starter loller
  • Start date Start date
L

loller

I want 6 lines of data in my table, but only 3 of those 6 lines in my chart-
how to I do that?
 
Hi,

You need to include all 6 in the chart in order to populate the data table.
You can then format 3 to have no Line style. This will remove them from the
chart.
You can also remove individual legend entries by selecting and deleting
them.

Cheers
Andy
 
You must log in or register to reply here.

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

How to chart months by financial year 0
Data tabels with charts 1
Not plot a data series in a chart but still display in data table 1
Display Info in Data Table That is Not Charted? 1
Different data series in table than in the line chart 1
How to create a bubble chart with more than 2 variables 0
Data table in chart? 3
Can you design your own chart in excel 2

Back
Top