scatter plot problem

  • Thread starter Thread starter pioneermusic55
  • Start date Start date
P

pioneermusic55

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"
 
Back
Top