If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
deleting legend keys in mixed line-scatter graph not correct
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 ? |
#2
|
|||
|
|||
deleting legend keys in mixed line-scatter graph not correct
Could you send me a copy of the file?
Get my email addy from my website best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rolando" wrote in message ... 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 ? |
Thread Tools | |
Display Modes | |
|
|