Struggling to plot where I want

[Scooby Jones]

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]

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

 

[Jon Peltier]

http://peltiertech.com/Excel/Charts/ClusterColAndLine.html

- Jon

 

[Scooby Jones]

Thanks Guys!

Saved me a whole load of headache ;o)

Carl.