deleting legend keys in mixed line-scatter graph not correct

R

Rolando

In Excel 2007, I have a mixed line-scatter chart with 4 line (labeld 'A' to
'D') and 4 scatter series (labeled 'A mean' to 'D mean') which represent
average values of respective line series. A to C and respective mean series
are linked to 1st Y-axis, D and D mean to 2nd Y-axis.
I only want to show keys for line series (A to D). When I delete the
non-wanted keys (all mean labels) Excel shows the correct legend. When I save
and reopen file, legend is messed-up; only serie keys A to C are shown, not
D, instead one of the mean keys is shown. Why is that ?
 
B

Bernard Liengme

Could you send me a copy of the file?
Get my email addy from my website
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

legend problem in mixed line-scatter graph Excel 2007 0
deleting specific legend keys in mixed line-scatter chart not corr 0
Overlay line graph points on bar graph 1
How do I adjust marker spacing in Excel scatter plot? 1
Excel 2007: Lines not displayed on Scatter Plot 0
Combined line-scatter graph with 2 Y-axis messed up 2
How do I specify X,Y axis and Series values in a line graph? 5
Employee Schedule not plotting properly - chart type / data series not correct 0

Top