scatter plot problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pioneermusic55 - 28 Jul 2006 18:18 GMT

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

Signature

pioneermusic55

Reply to this Message

Jon Peltier - 29 Jul 2006 03:43 GMT

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
_______

> 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
[quoted text clipped - 10 lines]
> i only need the marker between when a year changes.. any help on how to
> create this scatter plot would be appreciated

Reply to this Message