Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Urgent ..Need help | Excel Discussion (Misc queries) | |||
Please help me (urgent) | Excel Worksheet Functions | |||
urgent, help! | Excel Discussion (Misc queries) | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) |