EXCEL:any way to repress selected data from a chart, but still display it in a table below?

[TrojanWhore]

Hi guys, hopefully someone will know how to do this...

essentially, I need a way to have a chart (bar graph to be exact), which has the data table below it, but in such a way that one category in the table is not represented by a bar.

the table is laid out as such:

a | b | c | d | e | total

whereby total is the sum of 'a' to 'e'. so what is desired is that the 'total' category doesn't have a bar, as obviously, it is somewhat redundant, and more importantly, dwarfs all the other bars by comparison, making it hard to infer any values from the rest of them. I hope I have explained this clearly enough!
Thanks in advance for any help (or even taking the time to think it over or a few minutes!)

 

[Makhaira]

Just hide the column in the table - the chart will not show hidden columns. When you want to see the whole table, just unhide the column, job's a good 'un!

 

[Grenache]

Right-Click on the chart and select "Select Data". That allows you to add or remove lines/bars.

If you have Excel 2007 or 2010 it's as easy as that. For Excel 2003 just look at the ranges listed for each bar (including the X axis) and adjust them accordingly