Struggling to plot where I want
 

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.

Struggling to plot where I want
 

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

Scooby Jones wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Struggling to plot where I want
 

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

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


"Scooby Jones" wrote in message
...
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.

Struggling to plot where I want
 

Thanks Guys!

Saved me a whole load of headache ;o)

Carl.

"Jon Peltier" wrote in message
...
http://peltiertech.com/Excel/Charts/...olAndLine.html

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


"Scooby Jones" wrote in message
...
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.