Secondary axis not aligning to X axis
in [Charts]
|
Prev: Create Excel chart from merged cells
Next: On scatter chart, how can data points be moved with curser?
From: Katie on 7 Feb 2010 17:31 Hi, Our secondary series (scatter graph) is not aligning to the X axis values with the primary series (bar graph). The secondary series is aligning with the gridlines not the X axis values. The Primary is aligning with the X axis values as required. How do we make the Secondary series align with the X axis values like the Primary series is?
From: Bernard Liengme on 9 Feb 2010 08:24
If you open the Format Axis dialog for the column chart you will see a setting: Position Axis On tick marks OR Between tick marks For more detailed answers please tell us what version of Excel (2003- or 2007+) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Katie" <Katie(a)discussions.microsoft.com> wrote in message news:8F20F701-278A-4E64-9628-50C1B21FEFA3(a)microsoft.com... > Hi, > > Our secondary series (scatter graph) is not aligning to the X axis values > with the primary series (bar graph). > > The secondary series is aligning with the gridlines not the X axis values. > The Primary is aligning with the X axis values as required. > > How do we make the Secondary series align with the X axis values like the > Primary series is? > |