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

How do I specify X,Y axis and Series values in a line graph? 5
Combined line-scatter graph with 2 Y-axis messed up 2
How do I adjust marker spacing in Excel scatter plot? 1
Creating a Line graph 6
Add a horizontal line to a graph but not to the legend 2
How to prevent trend line info in legend? 1
XY Scatter graph: x-axis picking up row numbers instead of values 3
combination x-y scatter and column graph 5

Top