Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a custom chart [Excel 2003]
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a custom chart [Excel 2003]
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 ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a custom chart [Excel 2003]
your welcome and
thank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu for messege |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating custom charts in Excel 2007 | Charts and Charting in Excel | |||
Custom functions excel 2003 | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Creating custom chart legen pallettes/styles symbols | Charts and Charting in Excel | |||
Creating custom colours in Excel 2002 | Excel Discussion (Misc queries) |