1.

Solve : Excel 2007 hide cell??

Answer»
I there a way that i can hide a column but still keep the VALUES in a bar chart?

I have created a bar chart, but the x-axis was MADE from values in cells that are not in the chart table (the table has 10<20 and 20<30 etc, but the bar chart just need 10, 20, 30. So i just wrote the values in some FREE cells and used them) But EVERYTIME i hide them they disappear from the chart?TRY this:

http://www.techrepublic.com/blog/msoffice/display-hidden-data-in-an-excel-chart/1927


P.Thanks, i'll try that


Discussion

No Comment Found