Data Points in Excel Charts
 

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?

Data Points in Excel Charts
 

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.

"Cheezeman" wrote:

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?

Data Points in Excel Charts
 

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

"Sean Timmons" wrote:

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.

"Cheezeman" wrote:

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?

Data Points in Excel Charts
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Cheezeman" wrote in message
...
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

"Sean Timmons" wrote:

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.

"Cheezeman" wrote:

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?