+ Reply to Thread
Results 1 to 4 of 4

Need help with bar chart

  1. #1
    Registered User
    Join Date
    08-20-2015
    Location
    SLC
    MS-Off Ver
    2007
    Posts
    2

    Need help with bar chart

    Hey guys,

    I need a little help here with converting data from a excel sheet into a bar chart.

    Essentially, I am trying to take items from the "Device name" column, and have it be my vertical axis. I need each name on the vertical axis.

    For the horizontal, I need 4-6 quarters. Example, Q1-15, Q2-15, Q3-15, Q4-15, Q1-16, Q2-16. I was hoping that the dates I have under the column "projected release date" would then populate in correlation with how the quarters are setup.

    Any help would be much appreciated!

    Chart.jpg

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,620

    Re: Need help with bar chart

    (How to) Attach a Workbook
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-20-2015
    Location
    SLC
    MS-Off Ver
    2007
    Posts
    2

    Re: Need help with bar chart

    My bad.. The workbook is attached.

    Any help is much appreciated.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,620

    Re: Need help with bar chart

    If all you want to do is replace the 1 - 20 digits with the device name, then
    • Right click the chart, choose Select Data
    • Edit Horizontal axis labels: choose A4:a20
    Last edited by protonLeah; 08-24-2015 at 09:29 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  2. Chart order in trad. Pivot Chart vs. PowerPivot chart
    By mr_jules in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-06-2015, 11:17 AM
  3. Replies: 5
    Last Post: 12-05-2012, 12:07 PM
  4. Replies: 5
    Last Post: 08-08-2011, 02:09 PM
  5. can we combine line chart and colum chart in one chart
    By reedzhou in forum Excel General
    Replies: 1
    Last Post: 06-20-2011, 10:03 PM
  6. Replies: 6
    Last Post: 06-04-2010, 11:55 AM
  7. Replies: 2
    Last Post: 08-07-2006, 09:45 PM

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