+ Reply to Thread
Results 1 to 3 of 3

How to properly format this chart

  1. #1
    Registered User
    Join Date
    01-14-2019
    Location
    Oregon
    MS-Off Ver
    2019
    Posts
    1

    How to properly format this chart

    Hello!

    I am trying to create a chart that will plot "Assigned SP" and "Completed SP" as two separate lines vs the Sprint Name. I want the Sprint name to be on the horizontal axis, and Assigned SP and Complete SP to be plotted on the vertical axis, but every time I create a chart, I get the Sprint name, Assigned SP, and Completed SP all plotted on the y-axis with the row number on the horizontal axis.

    In short, my data set is in picture 1, when I create a chart, I get what's in picture 2, and I want a chart that is similar to picture 3. How do I format the chart to do this? Sorry if this is a super basic and easy question! I've been Googling for hours, and I cannot figure it out with switching all three types of data to the opposite axis. Thanks so much in advance!
    Attached Images Attached Images

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: How to properly format this chart

    It's not very useful to attach pictures - it would be better if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it does not work on this forum.

    Hope this helps.

    Pete

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: How to properly format this chart

    The second one is using a secondary axis, you need to format it with a secondary axis. (Sent from iPad)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. Unable to format date properly
    By treeantz in forum Excel General
    Replies: 4
    Last Post: 02-03-2016, 10:10 PM
  2. Unable to format Time Properly
    By longsh0t in forum Excel General
    Replies: 1
    Last Post: 12-03-2014, 01:20 PM
  3. How to properly chart this
    By bdrilling33 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-11-2014, 12:14 PM
  4. How to properly format IF/THEN
    By sos4excel in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-04-2014, 12:05 PM
  5. [SOLVED] Chart is not working properly
    By K m in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-29-2013, 01:16 PM
  6. [SOLVED] VBA not properly formatting pie chart
    By Kaziglu Bey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2012, 02:57 PM
  7. Format time properly?
    By Geuis in forum Excel General
    Replies: 1
    Last Post: 01-02-2005, 08:46 PM

Tags for this Thread

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