Chart Legend

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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/
_______
 
Back
Top