Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 9th 09, 03:31 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 33
Default 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   Report Post  
Old July 9th 09, 07:51 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1,104
Default 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   Report Post  
Old July 9th 09, 08:56 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 33
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combined bar/Line graph defaults to bar Michael Anderson Charts and Charting in Excel 1 November 29th 07 01:20 PM
scatter and line combined Ray Pendergast Charts and Charting in Excel 3 August 17th 07 01:53 AM
combined scatter plot and line data bmayers Excel Discussion (Misc queries) 2 June 25th 06 06:11 PM
why is the y-axis label in the Excel graph always messed up? Song Charts and Charting in Excel 3 April 2nd 05 04:51 AM
Time axis column and scatter/line graph kraymond Charts and Charting in Excel 5 February 8th 05 11:34 PM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017