Thread: 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

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@excelforum-nospam.com> wrote in
message news:pioneermusic55.2bo17f_1154107209.6292@excelforum-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
>