Creating a custom chart [Excel 2003]

Discussion in 'Excel Charting' started by danhaman, Dec 7, 2007.

  1. danhaman

    danhaman Guest

    Is there a way to combine a stackable bar graph and a line graph? Or to add
    a data field to a stackable bar graph that lies outside of the stacked data?

    Basically what I'm trying to do is stack each quarters accomplishments as a
    running total, but display the goal [in this case, as a line at the top, but
    a separate bar next to the running total would work as well]. The x-axis
    will be all the players, who must achieve different goals.

    Thanks for your help.

    danhaman, Dec 7, 2007
    1. Advertisements

  2. danhaman

    Jon Peltier Guest

    Ignore the "built-in custom" types. Make a stacked chart with the stack data
    (or all data if it's connected). If the line data is not included, copy it,
    select the chart, use Edit menu > Paste Special to add the data as a new
    series. Select the series you want to change to a line, go to Chart menu >
    Chart Type, and change it.

    - Jon
    Jon Peltier, Dec 7, 2007
    1. Advertisements

  3. danhaman


    your welcome and

    thank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu for messege
    , Jan 15, 2013
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.