C
Cheezeman
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?
of data out of three in the table. Is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sean Timmons
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.
click the Series tab, and remove the Series you don't want.
C
Cheezeman
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
I remove a series it doesn't show when I display the data table
A
Andy Pope
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
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