Chart Series Not displayed
 

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

Chart Series Not displayed
 

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

Barb Reinhardt wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Chart Series Not displayed
 

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



Andy Pope wrote:
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

Barb Reinhardt wrote:
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