Chart legend error

February 16, 2008

I'm making an XY scatter chart with joining lines & straight trend 
lines, showing blood pressures against time.

The date & time of each test are recorded, & added to give a date-time 
number for charting purposes. That date-time number reads on the X axis 
with the pressures on the Y axis

The columns of data I use for the chart are C (date-time); D (Systolic) 
& E (Diastolic). The bracketed words are the column heading in row 1. C 
is hidden.

1. The legend displays the Systolic & Diastolic colours correctly, but 
defaults to label the Systolic colour "date-time", the heading on
hidden 
column C, instead of the desired heading on Column D. The systolic 
pressures are shown correctly. I can change the label to "Systolic" in

the "Source data" pop-up, but if I save the file & exit, when I
re-open 
it that legend label reverts to "date-time".  How can I change this
& 
make the change stick?

Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM

Don Codling wrote:
> 
> February 16, 2008
> 
> I'm making an XY scatter chart with joining lines & straight trend 
> lines, showing blood pressures against time.
> 
> The date & time of each test are recorded, & added to give a
date-time 
> number for charting purposes. That date-time number reads on the X axis 
> with the pressures on the Y axis
> 
> The columns of data I use for the chart are C (date-time); D (Systolic) 
> & E (Diastolic). The bracketed words are the column heading in row 1. C

> is hidden.
> 
> 1. The legend displays the Systolic & Diastolic colours correctly, but

> defaults to label the Systolic colour "date-time", the heading on
hidden 
> column C, instead of the desired heading on Column D. The systolic 
> pressures are shown correctly. I can change the label to
"Systolic" in 
> the "Source data" pop-up, but if I save the file & exit, when
I re-open 
> it that legend label reverts to "date-time".  How can I change
this & 
> make the change stick?

Sounds like a bug to me.  What happens if you unhide column C and save?  How are

your chart data series specified -- C1..Cwhatever or C2..Cwhatever?

Uli

Don Codling wrote:
> The legend displays the Systolic & Diastolic colours correctly, but 
> defaults to label the Systolic colour "date-time", the heading on
hidden 
> column C, instead of the desired heading on Column D.

In light of the newer charting engine in v12, I don't know how my interface (v8)

corresponds to yours, but check your cell range entry for "Legend" in
the "Chart 
Series" window (i.e., the popup which lists ALL your data series, not just
one 
selected series):  it should be D1..E1, not C1..E1.  Strictly speaking, in v8 
the legend entry here will be overridden by what you enter in the individual 
data series popup, but it seems in v12 that's not the case.

Cheers,
Uli

February 17, 2008

Thank you for your help Uli & Roy. I had changed the Legend label for my 
series 1, but not the legend labels range. Changing that from C1..E1 to 
D1..E1 made my label corrections tick.

I appreciate the help.

Now I have to try to get my X axis to display dates instead of 
non-Julian date numbers. I've copied the suggestions from previous 
threads, but don't be surprised if I come back pleading for further 
enligtenment!

Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM

lemoto wrote:
> Uli:
>   
>> check your cell range entry for "Legend" in the "Chart 
>> Series" window (i.e., the popup which lists ALL your data series,
not just one 
>> selected series):  it should be D1..E1, not C1..E1.
>>     
>
> Agree. Right-click Chart, Source Data brings up the Dialog.
>
>   
>> Strictly speaking, in v8 
>> the legend entry here will be overridden by what you enter in the
individual 
>> data series popup, but it seems in v12 that's not the case.
>>     
>
> I think that the presentation is different, but the option (override Legend

> labels previously taken from the Sheet) remains.
>   

Uli:
> check your cell range entry for "Legend" in the "Chart 
> Series" window (i.e., the popup which lists ALL your data series, not
just one 
> selected series):  it should be D1..E1, not C1..E1.

Agree. Right-click Chart, Source Data brings up the Dialog.

> Strictly speaking, in v8 
> the legend entry here will be overridden by what you enter in the
individual 
> data series popup, but it seems in v12 that's not the case.

I think that the presentation is different, but the option (override Legend 
labels previously taken from the Sheet) remains.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)