Combined line-scatter graph with 2 Y-axis messed up

R

Rolando

I have a chart in Excel 2007 (under XP sp3) with 2 line (L1 & L2) and 2
scatter series (S1 & S2, representing means of respectively L1 and L2
datapoints).
Both L-points are located at last datapoint-position.
X-values are formatted as 'Genereal'.
Both L1 and S1 are referenced to 1st Y-axis, only L2 to 2nd Y-axis.
Here's where the error comes in.

When I reference S2 also to Y2, it looks ok until I saved the sheet and
reopen it,
After reopening, THE CHART IS GONE !
AFTER PREVIEW, IT REAPPEARS BUT THE FORMAT IS TOTALLY MESSED UP ?!
Both Y-axes are shrinken and L2 and S2 disappeared
what's wrong ?
 
B

Bernard Liengme

Why are you mixing Line and XY?
It would seem that all your series could be plotted as XY series
Line charts are used for categorical data
best wishes
 
R

Rolando

perfect ! problem solved
I didn't knew mixing line/scatter series might give problems, however...
if I reopen the same sheet, with the error on my laptop, on a 2nd PC...
there is NO problem, everything is normal, and...with mixed series !?
how can this be explained, differences between PCs ?
thanx anyway
 

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

Top