| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to change bar to line in line-column on 2 axes chart in Excel2
I have 3 series of data - Qty, TAT & Target. I would like Qty to be bar while
other 2 to be line on seperate axes. When I select custom type line-column on 2 axes, it will give me Qty & TAT as bar while Target as line. How do I change TAT to line? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to change bar to line in line-column on 2 axes chart in Excel2
Hi,
Single click the series you want to change and choose Chart, Chart Type and pick the chart type you want. Cheers, Shane "jaysan3" wrote in message ... I have 3 series of data - Qty, TAT & Target. I would like Qty to be bar while other 2 to be line on seperate axes. When I select custom type line-column on 2 axes, it will give me Qty & TAT as bar while Target as line. How do I change TAT to line? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to change bar to line in line-column on 2 axes chart in Ex
It works. Thanks very much, Shane.
"Shane Devenshire" wrote: Hi, Single click the series you want to change and choose Chart, Chart Type and pick the chart type you want. Cheers, Shane "jaysan3" wrote in message ... I have 3 series of data - Qty, TAT & Target. I would like Qty to be bar while other 2 to be line on seperate axes. When I select custom type line-column on 2 axes, it will give me Qty & TAT as bar while Target as line. How do I change TAT to line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
| How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
| Combination chart - Line - Column on 2 Axes | Charts and Charting in Excel | |||
| Line - Column 2 Axes chart question | Charts and Charting in Excel | |||
| My Custom Line-Column 2 axes Chart dsn't work with +6sets of cells | Charts and Charting in Excel | |||
Linear Mode
