scatter plot problem
 

Basically i want to create a scatter plot using the data provided
below... but i want the x axis to go by month and then have a year
marker... all i can seem to get is either all the months, or all the
years, but not both together...

2003 SEP $0.05453 OCT $0.05178
2003 NOV $0.05228
2003 DEC $0.05543
2004 JAN $0.05990
2004 FEB $0.06034
2004 AVG $0.05570


i only need the marker between when a year changes.. any help on how to
create this scatter plot would be appreciated


--
pioneermusic55
------------------------------------------------------------------------
pioneermusic55's Profile: http://www.excelforum.com/member.php...o&userid=36756
View this thread: http://www.excelforum.com/showthread...hreadid=566095

scatter plot problem
 

This might be a good place for a line chart, which will allow you the
categories across the X axis that I think you are describing. You can double
click on the series, and on the Patterns tab remove the lines between the
points.

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


"pioneermusic55"
<pioneermusic55.2bo17f_1154107209.6292@excelforu m-nospam.com wrote in
message news:pioneermusic55.2bo17f_1154107209.6292@excelfo rum-nospam.com...

Basically i want to create a scatter plot using the data provided
below... but i want the x axis to go by month and then have a year
marker... all i can seem to get is either all the months, or all the
years, but not both together...

2003 SEP $0.05453 OCT $0.05178
2003 NOV $0.05228
2003 DEC $0.05543
2004 JAN $0.05990
2004 FEB $0.06034
2004 AVG $0.05570


i only need the marker between when a year changes.. any help on how to
create this scatter plot would be appreciated


--
pioneermusic55
------------------------------------------------------------------------
pioneermusic55's Profile:
http://www.excelforum.com/member.php...o&userid=36756
View this thread: http://www.excelforum.com/showthread...hreadid=566095