ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how can i get a "Column - Line on 2 axes" graph? (https://www.excelbanter.com/charts-charting-excel/160103-how-can-i-get-column-line-2-axes-graph.html)

bunjoy

how can i get a "Column - Line on 2 axes" graph?
 
Under Chart type... there is a built-in category....i see that it has
line-column on 2 axes..but i wanted to know if its possible to have it the
other way around...
that is: One column and 2 Lines showing on my graph.
Help?
please

Jon Peltier

how can i get a "Column - Line on 2 axes" graph?
 
Those built-in custom charts are occasionally helpful, unless you want
something different.

Build the combination chart yourself. Create a line chart with all of your
data, then select the series you want to display as columns, go to Chart
menu Chart Type, and choose a column type for this selected series. If you
want any series on the secondary axis, double click on it, and on the Axis
tab, choose Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"bunjoy" wrote in message
...
Under Chart type... there is a built-in category....i see that it has
line-column on 2 axes..but i wanted to know if its possible to have it the
other way around...
that is: One column and 2 Lines showing on my graph.
Help?
please





All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com