Chart Series Not displayed

[Barb Reinhardt]

I have 15 chart series in my chart. When I view them on the 'command line'
within the chart, I only see 14. When I view them through the Chart ->
Source data page, I see 15 series. The 15th series is not being displayed
on the chart. Where is it and what do I need to do to get it to display?

Thanks,
Barb Reinhardt

 

[Andy Pope]

Hi,

I assume by 'command line' you mean formula bar.

The series formula will only appear if the series has valid data. If you
have empty cells or #N/A's then it will not appear.

Cheers
Andy

 

[Gklass]

There are many things that can cause this

Mostly it is caused by data that is outside the range of the y axis
scale -- or hidden at the bottom at 0.

Is it possible that one of your data series is formatted as a
percentage? if your range is 0 to 100 and your data series look like this:

a b c d
95 55 88 85%

the 85% will be plotted as if it is .85