Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combined line-scatter graph with 2 Y-axis messed up
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 ? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combined line-scatter graph with 2 Y-axis messed up
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rolando" wrote in message ... 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 ? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combined line-scatter graph with 2 Y-axis messed up
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 "Bernard Liengme" wrote: 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rolando" wrote in message ... 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combined bar/Line graph defaults to bar | Charts and Charting in Excel | |||
scatter and line combined | Charts and Charting in Excel | |||
combined scatter plot and line data | Excel Discussion (Misc queries) | |||
why is the y-axis label in the Excel graph always messed up? | Charts and Charting in Excel | |||
Time axis column and scatter/line graph | Charts and Charting in Excel |