Plotting against Date (collating months)

Discussion in 'Excel Charting' started by irving.liaw@gmail.com, Feb 15, 2013.

  1. Guest

    To track usage of pieces of equipment, I use Excel.
    I have a couple of data columns:

    Date (by Day) - Equipment Name - Hours - $ collected

    I'd like to plot a number of graphs.

    1. $ Collected Vs Date (by day) -> (Done easily)

    2. Bar graph of : Equipment Vs Date (by month) (so if I have 3 pieces of Equipment, I will see a graph of 3 bars in each month.
    3. Total Hours Vs Date (by month)
    4.Total $collected Vs Date (by month) -> Thinking that 1. was easy to do, I changed the X-axis to do months but it didn't give the Total $ collected. Instead it showed the highest charge that month.

    Anyone help?
     
    , Feb 15, 2013
    #1
    1. Advertisements

  2. Spencer101 Guest

    ;1609382 Wrote:
    > To track usage of pieces of equipment, I use Excel.
    > I have a couple of data columns:
    >
    > Date (by Day) - Equipment Name - Hours - $ collected
    >
    > I'd like to plot a number of graphs.
    >
    > 1. $ Collected Vs Date (by day) -> (Done easily)
    >
    > 2. Bar graph of : Equipment Vs Date (by month) (so if I have 3 pieces o
    > Equipment, I will see a graph of 3 bars in each month.
    > 3. Total Hours Vs Date (by month)
    > 4.Total $collected Vs Date (by month) -> Thinking that 1. was easy t
    > do, I changed the X-axis to do months but it didn't give the Total
    > collected. Instead it showed the highest charge that month.
    >
    > Anyone help?


    Could you provide some sample data in a workbook?
    Makes it far easier to help out that way


    --
    Spencer101
     
    Spencer101, Feb 15, 2013
    #2
    1. Advertisements

  3. Guest

    Hi again,

    Nothing private so I've uploaded the tracking file here-> http://db.tt/AxYNCGdp

    Thanks for whatever help forthcoming.
     
    , Feb 17, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Annoyed by Excel

    Graph not plotting what it should be plotting

    Annoyed by Excel, Sep 4, 2003, in forum: Excel Charting
    Replies:
    2
    Views:
    257
    Jon Peltier
    Sep 5, 2003
  2. thone

    Date plotting problem, please help

    thone, Dec 7, 2003, in forum: Excel Charting
    Replies:
    3
    Views:
    196
    Jon Peltier
    Dec 8, 2003
  3. ValerieD

    Plotting two series against each other

    ValerieD, Oct 6, 2006, in forum: Excel Charting
    Replies:
    1
    Views:
    118
    David Biddulph
    Oct 6, 2006
  4. PierreL
    Replies:
    8
    Views:
    162
    PierreL
    Jun 12, 2007
  5. Midjack

    Time-date chart plotting

    Midjack, Mar 7, 2008, in forum: Excel Charting
    Replies:
    13
    Views:
    131
    Jon Peltier
    Apr 10, 2010
  6. mccredda

    Plotting Date and Time on the same chart axis

    mccredda, Feb 19, 2009, in forum: Excel Charting
    Replies:
    1
    Views:
    87
    Jon Peltier
    Feb 19, 2009
  7. Nick_F
    Replies:
    2
    Views:
    100
    Nick_F
    May 20, 2009
  8. Mal
    Replies:
    1
    Views:
    88
    Luke M
    Aug 25, 2009
Loading...