+ Reply to Thread
Results 1 to 8 of 8
  1. #1
    Registered User
    Join Date
    10-11-2007
    Posts
    9

    Post Clusterd Column Chart

    I am completely new to using excel and I have never created any kind of chart before. I would like to create a clustered column chart that displays total travel cost by each month.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    460
    hi jgwade99,

    Can you attach the xl file instead. Thanks.
    Corine

  3. #3
    Registered User
    Join Date
    10-11-2007
    Posts
    9

    Question

    What is an xl file.

    The spreadsheet has an xls extension, but that is not a valid file extension that can be uploaded.

    I would be glad to upload whatever you need as long as I know how to do it.

  4. #4
    Valued Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    460
    Hi jgwade99,

    I mean the excel file. You can upload it here but first you have to zip it.
    Corine

  5. #5
    Registered User
    Join Date
    10-11-2007
    Posts
    9
    Hi Corine,

    Sorry for the confusion. Like I said earlier, I am new to all of this.

    I have attached the Spreadsheet as a zip file.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    460
    Hi jgwade99,

    See the attached xl file. You can enumerate the cost of travel each month by the example i have in the sheet and from there you can plot the graph.

    I've used a column chart type, you can change it to any chart type that suits you.

    Hope it helps you get started.
    Attached Files Attached Files
    Corine

  7. #7
    Registered User
    Join Date
    10-11-2007
    Posts
    9
    Thank you very much, I believe I was making it harder than it really was.

  8. #8
    Valued Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    460
    Hi jgwade99,

    Thanks for the feedback, I' m glad it helped you.
    Corine

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.2.0