Let me insert a standard column chart, and let's run through some options in adjusting the labels that appear in the horizontal category axis. The first thing you probably notice is that there are some gaps in the columns. This happens because Excel automatically sets the axis type to date, which makes sense since we have dates in the data.
Your graph will now look less 'gappy' as the dates category is now assumed to be not a dates in a time series but text; After applying these settings your graph will look more compact and professsional. Other Top Excel Tips You May Like 1. Shorten The Y Axis Labels On Your Excel Chart. 2. VIDEO-How To Delete Obsolete Items From Pivot Table. 3.When the Change Chart Type window appears, select the 4th chart under the Line Chart section. Click on the OK button. Now when you view the chart, you should see that Series 2 has changed to a line graph. However, we still need to set up a secondary Y-axis as Series 2 is currently using the primary Y-axis to display its data.Press with left mouse button on the "Column chart" button. The Excel column chart is created, shown in the picture below. Back to top. 1.2 Add a second series. Now it is time to build the line. I will now add more data, see cell range A9:B11 in the picture below. This series will be the horizontal line on the y-axis value 140.
In Excel, there is a quick trick to fix this. I get asked how to do this regularly, so figured it warrants a quick "how to" post. I'll focus on the x-axis using the above example—you could follow a similar process to create supercategory axis labels on the y-axis when that makes sense, too.To add a secondary horizontal axis, do the following: 1. Add the secondary vertical axis to any of the data series (see How to create two vertical axes on the same side). 2. Select the data series which you want to see using the secondary horizontal axis. 3. On the Chart Design tab, in the Chart Layouts group, click the Add Chart Element drop ...So let's take a look at eradicating a pattern line out of your Excel chart. On an un-stacked, 2-D, space, bar, column, line, inventory, xy (scatter), or bubble chart As soon as you already know the varied parts of an Excel graph/chart is is far easier to customise the chart.