How do I create my own custom combination charts?

MS EXCEL

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?

```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?

```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

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?

```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

```

```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?
```

```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
```

```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
```

```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.
```

```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?
```