Custom Charts

[playerbigdog]

How do you make a chart with two sets of information? One being a area chart
and the other being a line or column chart but each one on the same
gridlines/graph.

 

[Andy Pope]

Hi,

The simplest way is to create a chart of 1 type, Column for example,
based on all the data. Then select a series, right click and pick Chart
Type. Depending on the combination the same axis will be used.

Cheers
Andy

 

[playerbigdog]

So there is no way to take one set of data and make it a Area graph; and then
take a second set of data and make a line graph; while putting both the area
and line graph in the same chart and axis?

 

[Andy Pope]

Yes there is a way, as I described.

Create a chart based on both sets of data, can be either line or area.
Select one of the series and change it's chart type.

This will not work if you are using 3d types.

Cheers
Andy

 

[playerbigdog]

Ahh, yeah after you told you me the first i finally realized what you were
saying and figured it out I appreciate your help! Thanks