Another smaller dialog box is now visible on the screen, see image above. Press with left mouse button on 'Add' button.

Press with right mouse button on on the chart.Press with left mouse button on the 'Clustered column' button.

Press with left mouse button on the 'Column' chart button.The image above shows pictures above each column, I will below describe how I built this chart. Repeat step 7 and 8 with the remaining pictures.īack to top 2.I resized the picture to 25 px width first. Press with left mouse button on a x y scatter data point.Press with right mouse button on on x axis and press with left mouse button on 'Format Axis.'.Change it to x y (scatter) and press with left mouse button on 'Scatter with only markers'.Press with right mouse button on on the second series and press with left mouse button on 'Change Series Chart Type.'.Press with mouse on the 'Clustered column' button.īack to top 1.2 How to insert pictures above column chart names.Press with left mouse button on the 'Column' button, a pop-up menu appears.Watch this video to learn how to build the above chart or follow the instructions below the video.īack to top 1.1 How to create a column chart How to insert pictures above column chart item names How to add pictures to a bar chart axis?ġ.How to add pictures next to y-axis values?.How to add pictures next to chart columns?.Looking at the chart above, we can see that the lowest value displayed on the Y axis is -$100,000. Because we don’t like the Automatic value, we’ll have to change it to “Axis value”. This horizontal axis is the X-axis, which is controlled in this menu of the Y-axis.

Note in the image above under “Axis Options”, you can see that “Horizontal axis crosses” is set to “Automatic”. In the Format Axis window that pops up, make sure that the icon on the far-right is selected (it looks like a bar graph with 3 bars). With the axis selected, right click and go to “Format Axis”. You’ll know the axis is selected when there are blue dots in the corners of the selection, like the image below. The first thing you need to do is click on the Y-axis (yes, I know I said we’re moving the X-axis – that’s what’s so confusing!) It may require two clicks, one on the chart and then another on the axis. Let’s say you have the following graph, and you need to move the X-axis down to avoid coverup up the line. I had a tough time finding the exact series of steps to get an axis to move in Excel (either the X-axis up and down, or the Y-axis left and right).

Change excel graph axis label