Urgent Help
 

Hi All,

I have a data as follows

A B C D
May-09 Jun-09 Jul-09
Change 10 50 90
Incident 10 50 90
Problem 10 50 90

I want Bar Chart for Change & Incident but for Problem I want line both has
2 be in same chart is it possible.

TIA

Urgent Help
 

Hi,

Create a bar chart for all 3 series and then select the problem series
and change the chart type to Line.

If you mean horizontal bar rather then column when you say bar then the
line chart would have to be xy-scatter in order to go up rather than
across the chart

Cheers
Andy

kiran wrote:
Hi All,

I have a data as follows

A B C D
May-09 Jun-09 Jul-09
Change 10 50 90
Incident 10 50 90
Problem 10 50 90

I want Bar Chart for Change & Incident but for Problem I want line both has
2 be in same chart is it possible.

TIA


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Urgent Help
 

Hi Andy,
Thanks for the replay as I'm new to excel can u tell me in steps how to do it
TIA

"Andy Pope" wrote:

Hi,

Create a bar chart for all 3 series and then select the problem series
and change the chart type to Line.

If you mean horizontal bar rather then column when you say bar then the
line chart would have to be xy-scatter in order to go up rather than
across the chart

Cheers
Andy

kiran wrote:
Hi All,

I have a data as follows

A B C D
May-09 Jun-09 Jul-09
Change 10 50 90
Incident 10 50 90
Problem 10 50 90

I want Bar Chart for Change & Incident but for Problem I want line both has
2 be in same chart is it possible.

TIA


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Urgent Help
 

Thanks Andy I got it Thanks a lot

"Andy Pope" wrote:

Hi,

Create a bar chart for all 3 series and then select the problem series
and change the chart type to Line.

If you mean horizontal bar rather then column when you say bar then the
line chart would have to be xy-scatter in order to go up rather than
across the chart

Cheers
Andy

kiran wrote:
Hi All,

I have a data as follows

A B C D
May-09 Jun-09 Jul-09
Change 10 50 90
Incident 10 50 90
Problem 10 50 90

I want Bar Chart for Change & Incident but for Problem I want line both has
2 be in same chart is it possible.

TIA


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info