Chart with 4 different axis ?
in [Charts]
|
Prev: excel charts look drastically different on different computers
Next: Secondary Row Group not displaying second value
From: H.G. Lamy on 29 Jan 2010 11:57 Hello, for a particular analysis I would like to use all 4 axis with different label (scales). Is that feasable, and if so, how can I tackle the task? Thank you in advance! Kind regards, H.G. Lamy
From: Mike Middleton on 29 Jan 2010 14:41 H.G. Lamy - Create a chart with two or more data series. Select one data series and use Format Axis to change it to secondary axis. If necessary, use Chart Options to display all axes. Format each axis, paying attention to Patterns tick mark and label locations and to Scale max, min, and crosses at. For more specific instructions, specify your version of Excel. An example ChartWithFourDifferentAxes, created using Excel 2003 SP3, is available at http://www.MikeMiddleton.com. - Mike "H.G. Lamy" <Enterplan(a)web.de> wrote in message news:#lcemQQoKHA.1544(a)TK2MSFTNGP06.phx.gbl... Hello, for a particular analysis I would like to use all 4 axis with different label (scales). Is that feasable, and if so, how can I tackle the task? Thank you in advance! Kind regards, H.G. Lamy
From: H.G. Lamy on 1 Feb 2010 18:45
I start to get to grips with it, slowly. Thank you, Mike. Regards, hgl "Mike Middleton" <Mike(a)MikeMiddleton.com> wrote in message news:utpBbsRoKHA.5224(a)TK2MSFTNGP05.phx.gbl... > H.G. Lamy - > > Create a chart with two or more data series. Select one data series and > use > Format Axis to change it to secondary axis. If necessary, use Chart > Options > to display all axes. Format each axis, paying attention to Patterns tick > mark and label locations and to Scale max, min, and crosses at. > > For more specific instructions, specify your version of Excel. > > An example ChartWithFourDifferentAxes, created using Excel 2003 SP3, is > available at http://www.MikeMiddleton.com. > > - Mike > > > > "H.G. Lamy" <Enterplan(a)web.de> wrote in message > news:#lcemQQoKHA.1544(a)TK2MSFTNGP06.phx.gbl... > Hello, > > for a particular analysis I would like to use all 4 axis with different > label (scales). > Is that feasable, and if so, how can I tackle the task? Thank you in > advance! > > Kind regards, > > H.G. Lamy > |