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.




Jon Peltier

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


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. After that, you can post your question and our members will help you out.

Ask a Question