Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / February 2007

Tip: Looking for answers? Try searching our database.

XY Scatter with Column Chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brettmanning24@gmail.com - 26 Feb 2007 11:56 GMT
Hello,

I have a XY scatter chart which has been created with different size
gaps on the x-axis.  I would now like to add a column chart to my XY
Scatter.  I can add the column chat but it does not align with the
points on the x-axis used by the XY Scatter, how can I do this?

Thanks

Brett
Bernard Liengme - 26 Feb 2007 14:22 GMT
I think you need to make a Line chart and then turn one (or more) data
series into column charts. The properties of an XY chart when the x spaces
differ make a combination impossible.
best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hello,
>
[quoted text clipped - 6 lines]
>
> Brett
Mike Middleton - 26 Feb 2007 17:41 GMT
Brett  -

You might be able to get what you want by changing the Min, Max, and Major
unit for the XY data series. Click once on a point to select the data
series, and choose Format | Axis | Scale.)

You can see my example of Column chart type with XY (Scatter) chart type on
the Histogram page at http://www.treeplan.com.

-  Mike
http://www.mikemiddleton.com

> Hello,
>
[quoted text clipped - 6 lines]
>
> Brett
Del Cotter - 26 Feb 2007 19:55 GMT
>I have a XY scatter chart which has been created with different size
>gaps on the x-axis.  I would now like to add a column chart to my XY
>Scatter.  I can add the column chat but it does not align with the
>points on the x-axis used by the XY Scatter, how can I do this?

One of the freaky things you can do by exploiting the "Time axis" trick
for default category-based charts is changing the Category axis of a
column chart to Time-scale. This doesn't make the columns variable
width-- for that you have to fiddle with the area chart type-- but it
does make them variable *position*. However, the positions have to be
integers, and the maximum width of the column is 1 (when the gap width
in Options is set to 0. For higher numbers, it's narrower), so the more
integers you pack in to try to position them with precision, the
skinnier the columns get.

If you make a combination column chart with Time axis and XY chart, the
two types of series will be on different X- and Y-axes: one on First X
and Y axis and the other on Second. If you play with the scale
properties of the two axes, you should be able to get the dots of the
scatter graph to line up with the bars of the column graph. Don't forget
the Y axes also need to be lined up by hand, because they'll each adopt
their own most comfortable scale if you leave them on automatic.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.