+ Reply to Thread
Results 1 to 4 of 4

combo chart - how to make secondary axis (combo chart)

  1. #1
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    192

    Question combo chart - how to make secondary axis (combo chart)

    I have a bar chart showing the monthly expenses (office supplies). If you look to the right, there is a column for budget year of $15000. How do I make a secondary axis as a line for my budget? I manually drew the red horizontal line in my chart. That is the desired out come I need.

    I tried making the secondary axis but it doesn't show. please see my attached file.

    thank you


    Capture.PNG
    Attached Files Attached Files

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

    Re: combo chart - how to make secondary axis (combo chart)

    This page links to two different approaches to adding a horizontal line to a column chart: http://peltiertech.com/Excel/Charts/AddLine.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    192

    Re: combo chart - how to make secondary axis (combo chart)

    beautiful! thanks.. i will check it out and mark this thread solved after I go thru the steps.

    thank you

  4. #4
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    192

    Re: combo chart - how to make secondary axis (combo chart)

    i see it talks about adding a series of values to make the line, but in my case I dont have a series of values. its just $15000. However I think if I have the series, it may be better. I will mark this as solved for the time being. thank you

+ 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. combo chart - 2 axis and 3 line
    By paulr0700282 in forum Excel General
    Replies: 1
    Last Post: 10-05-2016, 10:25 AM
  2. Double Axis Horizontal Combo Chart - Clustered Bar + Line
    By PHAAQ001 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-08-2016, 10:10 AM
  3. [SOLVED] Chart Combo - Splitting X axis
    By Grat in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-31-2012, 09:58 AM
  4. Can't make secondary axis in bar chart
    By Angivan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-06-2005, 05:05 AM
  5. Replies: 2
    Last Post: 08-12-2005, 08:05 AM
  6. Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis
    By mw210461@yahoo.com in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2005, 05:05 PM
  7. how can i add a secondary y-axis to a bar chart (not a line chart)
    By edbianc in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-18-2005, 10:06 AM

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