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
 
Back
Top