| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to interchange datas of 'X' & 'Y' axes in a Line Chart
Column & Bar Charts juxtaposed to each otherin that 'X' axis in one chart
becomes'Y' axis in the other. Can't we do same with the Line Chart. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to interchange datas of 'X' & 'Y' axes in a Line Chart
Hi,
In order to swap a line chart you need to convert the chart type to xy-scatter and then adjust the ranges being used for x and y values. If the line chart currently has categorical data on the x axis you will need to do a little more work to swap the axes. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy RM Batcha wrote: Column & Bar Charts juxtaposed to each otherin that 'X' axis in one chart becomes'Y' axis in the other. Can't we do same with the Line Chart. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding series, this time with a 2 axes line chart | Charts and Charting in Excel | |||
| Change line in Chart | Charts and Charting in Excel | |||
| Creating a line chart with two X-axes!! | Excel Discussion (Misc queries) | |||
| Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
