LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 100
Default scatter chart won't accept primary axis

Can someone explain what is happening. I have a very standard line graph w/
dates in col.A & values in col.F. In cols. X&Y I have the following.

06/30/08 2.95 These pairs of data represent
trend lines in the
-- 07/25/08 4.21 original data.
"space"
08/04/08 3.41
0910/08 4.95
"space"
01/27/09 .36
02/11/09 .49
I select the two ranges, copy, select chart and ctrl+V. I choose this
secondary graph to be a scatter chart. It appears as I want except it needs
to be on the primary axis. I select axis option, primary axis. The
selection goes into a non-response period for quite a long time and leaves me
with a x-axis range from 2008 to 2093. If I add a third set of trend lines
the non-response time extends forever and it has no idea what range I want,
GeneS
 
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
how to switch the primary and secondary Y axis to opposite chart s alski_13 Charts and Charting in Excel 3 April 2nd 23 08:55 PM
how to indicate on chart which axis (primary or secondary) in use Tim Charts and Charting in Excel 1 August 5th 08 03:20 PM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Excel Discussion (Misc queries) 3 May 4th 06 01:58 AM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM


All times are GMT +1. The time now is 08:59 PM.

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

About Us

"It's about Microsoft Excel"