+ Reply to Thread
Results 1 to 5 of 5

Plotting X and Y Axes

  1. #1
    Registered User
    Join Date
    08-05-2014
    Location
    Orlando
    MS-Off Ver
    2007
    Posts
    5

    Plotting X and Y Axes

    Don't know why I am having such a hard time with this.......
    I just want to create a bar graph that display these two sets of numbers:

    Orders Dollars
    Nov-13 1,901 Nov-13 $2,037,525.76
    Nov-14 1,892 Nov-14 $2,271,476.00

    help.......

    Thanks,
    john

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Plotting X and Y Axes

    What do you want the chart to show exactly? Dollar value vs. number of orders? Dollar value vs. Date and number of orders vs. date? something else?

    Is there a reason for repeating the date in between the number of orders and the dollar value of the orders?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-05-2014
    Location
    Orlando
    MS-Off Ver
    2007
    Posts
    5

    Re: Plotting X and Y Axes

    Hello,
    No reason for the repeat dates. As for the display, I would like to have the orders on side of the bar graph and dollars on the other side (side\side). Thanks for any help you can offer.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Plotting X and Y Axes

    It sounds like it should be as easy as adding a secondary axis to this chart. Instructions for adding a secondary axis: http://office.microsoft.com/en-us/ex...165.aspx?CTT=1

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Plotting X and Y Axes

    If you want both set of data as columns you need to alter your data to prevent column overlay.

    You might eant to consider separating the 2 sets for each comparison.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Plotting two axes on a scatter graph
    By Climaxgp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-06-2010, 07:27 AM
  2. Plotting 2 different graphs on 1 set of axes
    By Christian411 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-19-2009, 07:39 AM
  3. Plotting on 2 vertical axes on the same plot
    By ady_mech in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-19-2008, 08:45 AM
  4. Plotting on Line column on 2 axes
    By Dharmesh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-25-2007, 05:43 AM
  5. [SOLVED] Plotting on primary and secondary axes with 'synchronised' y values
    By Neil in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-04-2006, 04:55 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