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

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

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
>