Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Creating a custom chart [Excel 2003]

your welcome and

thank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu for messege

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating custom charts in Excel 2007 glitterbug99 Charts and Charting in Excel 3 November 1st 07 03:39 PM
Custom functions excel 2003 NICOLA-ITALY Excel Worksheet Functions 0 September 28th 07 03:51 PM
Creating a Custom Excel Function to Calculate Gini Coefficients [email protected] Excel Worksheet Functions 3 February 21st 06 11:15 PM
Creating custom chart legen pallettes/styles symbols ChartDummy Charts and Charting in Excel 3 March 19th 05 04:20 AM
Creating custom colours in Excel 2002 Fletch Excel Discussion (Misc queries) 2 March 1st 05 06:55 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"