+ Reply to Thread
Results 1 to 6 of 6

Adding extra line to bar chart

  1. #1
    Registered User
    Join Date
    10-09-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    38

    Adding extra line to bar chart

    I've been given the task of producing a chart quickly and I'm not too familiar with this part of excel.

    Basically I want a bar chart as attached showing the values of expenditure areas in each year. This part is ok I think.

    I need to add a line showing the resources available in each year which will go down each year and cut into each bar showing what area isn't covered by resources. The data is in the file (highlighted yellow) but I'm not using this at the moment. Can I add a line in to show this?

    Also is it possible to start the vertical axis at more than 0 so that the chart only shows say 100,000 up to 400,000 so that the smaller boxed are clearer?

    Any help would be gratefully received. Many thanks.
    Attached Files Attached Files
    Last edited by FCFalkirk; 08-24-2017 at 05:05 PM. Reason: problem solved

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

    Re: Adding extra line to bar chart

    If I understand what you are doing, it should be easy to create a simply stacked column + line combination chart: http://www.excel-easy.com/examples/c...ion-chart.html

    1) Add the desired data as a new series to the chart (either copy-paste or use Select data dialog)
    2) Select the desired data series -> Change chart type -> line chart
    3) Format as needed

    It is possible to start the vertical axis at whatever value you want using the Format axis dialog -> check "manual" for axis min and enter value into text box. However, this could have the unintended consequence of obscuring the fact that area 1 is much larger than all of the other areas. It is your chart and you know what you are trying to communicate with this chart, but it could be worth considering if it is wise to have the value axis start at 1e5.
    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
    10-09-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Adding extra line to bar chart

    Many thanks for your reply.

    I have Excel 2010 but this doesn't seem to have the combo chart.

    I have attached the screen I see.

    Any ideas?
    Attached Images Attached Images

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

    Re: Adding extra line to bar chart

    My mistake. Did you read and follow the instructions I listed in my post? In our older versions of Excel, you don't create a combo chart at the point of chart creation, nor do you have built in "combo chart" options. You create a combo chart by changing the chart type of one of the data series in the chart (step 2 of the steps I posted above).

    You might search your help files for "combination chart" or similar, as I would expect microsoft to have included a page in your help files (2007 and 2002 both had easy to follow tutorials for creating combination charts in the help files).

  5. #5
    Registered User
    Join Date
    10-09-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Adding extra line to bar chart

    Many thanks for this. I will try this out when I can.

    Thanks again for your help.

  6. #6
    Registered User
    Join Date
    10-09-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Adding extra line to bar chart

    Thank you, MrShorty. With your guidance I managed to prepare a chart to do the job. Many thanks for sharing your expertise.

+ 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. Extra Set of Data Labels in Line Chart?
    By dsfcom in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-15-2012, 07:51 AM
  2. Replies: 6
    Last Post: 11-26-2012, 05:17 AM
  3. Adding extra labels to column chart
    By handerson0603 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-17-2012, 02:40 PM
  4. extra line in bar chart
    By MeenuSaini in forum Excel General
    Replies: 1
    Last Post: 07-19-2010, 08:44 AM
  5. Adding extra line in a Cell
    By amitmodi_mrt in forum Excel General
    Replies: 2
    Last Post: 10-04-2009, 07:10 AM
  6. Adding Extra Servers in Waiting Line
    By RatherConfuzed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-28-2007, 04:37 PM
  7. [SOLVED] How do I add an extra line to a line-column chart?
    By moose in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-23-2006, 01:35 PM
  8. [SOLVED] Chart with extra line
    By [email protected] in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-26-2005, 11:05 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