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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.