Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do I adjust marker spacing in Excel scatter plot?

I am creating a char in Excel 2007 with 2 data series. 1 data series
(revenue) with left Y axis uses column chart and another series (growth) uses
XY Scatter chart. Both of them use the same X axis values. The trouble is
that the two don't align on X axis marker. Is there a way to adjust spacing
between scatter markers to get everything align?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 563
Default How do I adjust marker spacing in Excel scatter plot?

Could you use a Line rather than XY?
Or there is an option to have the columns line up x-axis labels rather than
between them
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"ravim" wrote in message
...
I am creating a char in Excel 2007 with 2 data series. 1 data series
(revenue) with left Y axis uses column chart and another series (growth)
uses
XY Scatter chart. Both of them use the same X axis values. The trouble is
that the two don't align on X axis marker. Is there a way to adjust
spacing
between scatter markers to get everything align?

Thanks


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
adjust line spacing of text in a cell TC Excel Discussion (Misc queries) 4 May 18th 23 03:47 AM
Adjust line spacing when printing address labels in Excell ? lizreed Excel Worksheet Functions 1 August 22nd 09 11:12 PM
Legend in x-y Scatter chart does not show marker Peter K Charts and Charting in Excel 2 September 25th 06 11:38 AM
XY Plot Size of Marker A Pragmatic Cynic Charts and Charting in Excel 4 May 2nd 06 02:55 PM
How to adjust spacing between lines of wrapped text ? SUZL Excel Discussion (Misc queries) 1 December 15th 05 10:51 PM


All times are GMT +1. The time now is 08:36 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"