Custom Charts
 

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.

Custom Charts
 

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Custom Charts
 

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" wrote:

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Custom Charts
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"playerbigdog" wrote in message
...
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" wrote:

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Custom Charts
 

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

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"playerbigdog" wrote in message
...
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" wrote:

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info