How do I create my own custom combination charts?

MS EXCEL

    Sponsored Links

    Next

  • 1. number & percent column chart
    To create from an excel chart picture: There are 2 series in a column chart. One numbered & the other next to it is in percent. Both series are exactly the the same height. How can I 'create' the 2 series of the chart in excel from the picture, so that the percent bar height matches the number bar. Thanks in advance
  • 2. Calculating or estimating the area between to curves
    I have seen some great posts about colouring the area between 2 lines but I need to calculate numerically the area between 2 lines. A close estimate would do. My curves are smoothed lines but they have many roots to fit a trendline whose equation I could have integrated. If I use straight lines between points I have too big an error. Even Simpsons Rule is not accurate enough at times. Is there a way that Excel can return a figure for the area under a curve - I could even use the number of pixels it has shaded between the 2 lines!
  • 3. Precision in Excel 2002
    Hello, All! I have read complaints about lack of agreement in the coefficients of polynomials obtained by fitting trendlines on the graph and those obtained from LINEST. I had occasion to do some experiments yesterday using a third order polynomial with Excel 2002 and, as far as I can tell, at the same number of decimal places the coefficient results are identical. The data used had random errors and was not from an exact curve. Can anyone tell me which versions of Excel can be relied on or else what problems I should look out for? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not
  • 4. how do i get the data in a chart to automatically update?
    I have several charts tied to a large spreadsheet. The data in the charts don't automatically update. How do I get these to update without actually redoing the formulas for each source data?>

How do I create my own custom combination charts?

Postby Vml2aTYz » Sat, 21 May 2005 23:25:29 GMT

I am trying to create a line-column custom chart but I would like the column 
chart to be a 100% stacked column not just a simple column chart  as 
determined by the custom chart in Excel.  I can't seem to figure out how to 
do that. Also, how does Excel determine what data points show up on the 
column part of the chart and what data point show up in the line part of the 
chart?  

RE: How do I create my own custom combination charts?

Postby Sm9obiBNYW5zZmllbGQ » Sun, 22 May 2005 03:28:18 GMT

Vivi,

As an example, to set up the combination Line 100% Stacked Column Chart, 
assume you have your data set up like below in the range A1:E6. 

	Ser 1	Ser 2	Ser 3	Ser 4
a	5	5	5	4
b	4	4	4	3
c	5	5	5	4
d	6	6	6	6
e	7	7	7	5

Select the entire range.  Then using the Chart Wizard, create a 100% Stacked 
Column Chart.  After the chart is created, you should have four series 
visible.

Click on the top series of the chart (series 4).  Right-click on your mouse 
and select Chart Type.  In the Chart Type dialog box >> Standard Types tab, 
choose the Line chart and hit OK.  The line should appear near the bottom of 
the chart.  

Click once on the line.  Right-click on your mouse and select Selected 
Object.  In the Format Data Series dialog box, go to the axis tab.  Choose 
Plot Series on secondary axis and hit OK.

You should now have a chart with percentages on the left Y axis and numbers 
on the right Y axis.  You will need to adjust the axis scale for the right Y 
axis to meet your needs.

Excel determines what data appears where by what youe entered in the 
source i.e. spreadsheet and by what axis youe assigned that source to. 

-- 
Regards,
John Mansfield
 http://www.**--****.com/ 





>> I am trying to create a line-column custom chart but I would like the column 
>> chart to be a 100% stacked column not just a simple column chart  as 
>> determined by the custom chart in Excel.  I can't seem to figure out how to 
>> do that. Also, how does Excel determine what data points show up on the 
>> column part of the chart and what data point show up in the line part of the 
>> chart?  

Re: How do I create my own custom combination charts?

Postby Jon Peltier » Sun, 22 May 2005 06:26:47 GMT

I generally preface an explanation like this by saying "Don't use the 
built-in custom chart types provided in Excel." I make a joke about the 
"built-in custom" oxymoron, then I point out that Excel exerts much 
control over the built-in types, usually at inopportune times, while you 
can make the chart do whatever you want if you build it yourself.

This sets the stage for the rest of John's description.

- Jon





Similar Threads:

1.How do I create my own custom button?

I am running 6 different macros on a daily basis, I have 6 yellow smiley face 
buttons as a shortcuts to each of the macros. I want to create a few 
different ones so I can associate them with the different macros I am 
running.  Can anyone help me?

2.Create 2-Axis Combination Chart XL 2007

In Excel 2007, there does not appear to be a chart type for combination 
charts.  I an trying to create a line-bar chart with the line on the left 
vertical axis and the bar on the right vertical axis.  
-- 
t2

3.Creating a combination chart opportunity

I am trying to create a chart that consists of two bars. The first bar needs 
to have multiple data ie. like a normal combination graph were the data is 
visually split in one bar by different colors. The second bar is another data 
set. I have never seen a chart set up this way, but wondering if possible and 
the solution to this. I have read that I should try a custom user define, or 
possibly set up first the combination graph and then add the second set of 
data. However I have been unsucessful in getting the two rows of bars, it 
always wants to put all three data sets into one row of bars. Thanks for 
reading and your help.

4.Creating a Combination Chart

I have 3 data series.  I would like to make Series 1 a clustered column, and 
Series 2 & 3 a stacked column.  Is that possible?  If so, could someone 
kindly tell me how to do it?  Thanks in advanced for any help.

5.How to create a stacked bar, line combination chart

I am having trouble creating a stacked bar  and line combination chart.  The 
standard excel charts offer a bar and line chart option, but does not seem to 
offer a
stacked bar and line option.

Has anyone done this type of chart?

6. how to create a clustered, 100% stacked combination chart

7. Creating a Combination Bar Chart with 2 Lines

8. How to create a combination chart?



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 8 guest