Divided Bar Graph Excel. Right click the Secondary series choose Format Series or similar it varies with Excel version and select the Secondary Axis option. Select Range A1A7 then select Range C1E7 with holding the Ctrl key and insert a chart with clicking the Insert Column or Bar Chart or Column.
Once youve formatted your data creating a bar chart is as simple as clicking a couple buttons. Now lets see how to create a bell curve in Excel. Nov 24 2014 Lets create a clustered column chart of the above data.
In my case I want to split the sale amounts.
Step 3 The following chart is now created. In the Charts section youll see a variety of chart symbols. Right click the Secondary series choose Format Series or similar it varies with Excel version and select the Secondary Axis option. Once youve formatted your data creating a bar chart is as simple as clicking a couple buttons.
