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

Soldato
Joined
13 Sep 2010
Posts
2,546
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!)
 
Back
Top Bottom