Chart Legend

[Guest]

Hi i have charts that i need to update daily.The source data sometimes has
positve numbers but mostly 0's.I need to report only the positve values When
i update the chart i get the correct value in the chart but the legend still
displays the next entries from the source data.This can be very confusing Is
there a way to display only the legend entires that have a positve value in
the chart?

tks

 

[Jon Peltier]

You could use an autofilter to hide the rows with zero values, or maybe a pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Thanks,,,works like a charm

You could use an autofilter to hide the rows with zero values, or maybe a pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______