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 / October 2006

Tip: Looking for answers? Try searching our database.

Struggling to plot where I want

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scooby Jones - 31 Oct 2006 13:25 GMT
Hi Group

I hope I can explain what I am looking for...

I want to plot 2005 data, side by side with 2006 data, something like this :

2005                     2006
2005 2006   2005 2006   2005
2005 2006   2005 2006   2005
2005 2006   2005 2006   2005 2006
2005 2006   2005 2006   2005 2006

Liverpool      London         Manchester

I can do that bit fine.  I then want to add in a penetration line into the
graph for both 2005 and 2006, again I can do this fine but I have a problem
with the way Excel lines up the points of the line.

Both lines (2005 and 2006) position themselves at the mind point of the 2005
2006 data, like this (full stops within illustration below) :

2005.
2005 2006
2005.2006

What I would like to be able to do is to make the 2005 point to be centred
in the 2005 data and the 2006 point to be centred in the 2006 data (almost
offsetting the 2005 data a touch to the left, and the 2005 data a touch to
the right), like this :

20.05
2005  2006
2005  20.06

For the life of me I can't work out how to do it - any help appreciated ;o)

Many thanks in advance.

Carl.
Andy Pope - 31 Oct 2006 13:39 GMT
Hi,

You will need to plot the lines as XY scatter rather than Line chart.
This will allow you to specify the x position for each series.
Values like this should give you the center of each column but it will
depend on your gap width setting.

X 2005    X 2006
0.85    1.15
1.85    2.15
2.85    3.15
3.85    4.15
4.85    5.15

Cheers
Andy

> Hi Group
>
[quoted text clipped - 35 lines]
>
> Carl.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Jon Peltier - 31 Oct 2006 13:43 GMT
http://peltiertech.com/Excel/Charts/ClusterColAndLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Hi Group
>
[quoted text clipped - 36 lines]
>
> Carl.
Scooby Jones - 31 Oct 2006 13:46 GMT
Thanks Guys!

Saved me a whole load of headache ;o)

Carl.

> http://peltiertech.com/Excel/Charts/ClusterColAndLine.html
>
[quoted text clipped - 46 lines]
>>
>> Carl.
 
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.