+ Reply to Thread
Results 1 to 2 of 2

scatter plot problem

  1. #1
    Registered User
    Join Date
    07-25-2006
    Posts
    6

    Red face 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

  2. #2
    Jon Peltier
    Guest

    Re: 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@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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1