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.

    dh
     
    danhaman, Dec 7, 2007
    #1
    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, Microsoft Excel MVP
    Tutorials and Custom Solutions
    Peltier Technical Services, Inc. - http://PeltierTech.com
    _______


    "danhaman" <> wrote in message
    news:...
    > 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.
    >
    > dh
    >
    >
     
    Jon Peltier, Dec 7, 2007
    #2
    1. Advertisements

  3. danhaman

    Guest

    your welcome and

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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bridget Stacy

    Creating a 2 axes custom chart

    Bridget Stacy, Jan 29, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    72
    Jon Peltier
    Jan 30, 2004
  2. mnjiodek
    Replies:
    6
    Views:
    197
    mnjiodek
    Jun 17, 2004
  3. ChartDummy
    Replies:
    3
    Views:
    94
    Jon Peltier
    Mar 19, 2005
  4. Ted M H
    Replies:
    5
    Views:
    138
    ShaneDevenshire
    Jun 30, 2008
  5. Mark M
    Replies:
    1
    Views:
    108
    Del Cotter
    Aug 20, 2008
  6. sansk_23

    //excel chart as object to excel chart .

    sansk_23, Aug 26, 2008, in forum: Excel Charting
    Replies:
    1
    Views:
    122
    Andy Pope
    Aug 26, 2008
  7. Julius
    Replies:
    2
    Views:
    165
    Julius
    Mar 6, 2009
  8. Matt G
    Replies:
    1
    Views:
    129
    Shane Devenshire
    Jun 17, 2009
Loading...