Data Points in Excel Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to diplay a data table in a chart, but I only want to plot one column
of data out of three in the table. Is this possible?
 
Sure. Right-click in the white portion of the chart, select Source Data...
click the Series tab, and remove the Series you don't want.
 
But I still want all three columns to show when I display the data table. If
I remove a series it doesn't show when I display the data table
 
Hi,

The best you can do is format the unwanted series to have no border or fill.
As you have a column chart, assuming it is not stacked, you can set the
Overlap value to 100 and this will give the appearance of 1 column per
category rather than 3.
You can also remove individual legend items from the legend.
The only draw back will be if you are displaying legend key within the data
table.

Cheers
Andy
 

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

set cell to empty 1
Charting: Multiple workbooks one chart 3
Bizarre chart behaviour when changing axis cross at points 2
plot range in excel chart 2
Unabe to move data plots on chart in Excel 2007 1
Excel 2007 chart problem with existing spreadsheet 3
x-axis scaling 2
Chart display of no value cells 1

Back
Top