How to Create Formatting Charts in Advanced Excel?

Chart formatting is used to easily add a certain set of styles such as colors, patterns for data representation, legends, axis title, chart title, etc. We add these formatting styles to enhance the visualization of charts and also, it will help for data analysis. One of the best ways to format the charts is to use built-in formatting tools provided by Excel. The Format Pane is introduced in Excel 2013 which provides a chart formatting option for various different chart elements. In order to access the formatting pane, we need to Select Chart Element > Right-Click > Format<chart_element> excel will open a Format Pane for that particular chart element on the right side of the spreadsheet.

Steps to create a Formatting Chart in Excel

In this example, we will create a column chart and format its various chart elements. We will use random sales data for different courses for this.

Step 1: Create Dataset

In this step, we will be creating the dataset using the following random sales data for different courses.

Fig 1 – Dataset

Step 2: Insert Chart

Now, we will be inserting the chart for our dataset. In order to do this, we need to Select Data and then navigate to Insert. Then click on Charts and then select Column Chart there.

Fig 2 – Insert Chart

By doing this, Excel will automatically insert a column chart for our dataset.

Fig 3 – Column Chart

Step 3: Format Axis

In this step, we will format the chart axis. For this first Select Axis and then Right-Click on it and then select Format Axis.

Fig 4 – Format Axis

Once we click on Format Axis option, Excel will automatically open a Format Axis Pane.

Fig 5 – Format Axis

Using the format axis pane, we can format our chart axis according to our requirements. Here, we are going to change units to display in Hundreds and Tick Mark as Inside for Minor Type.

Fig 6 – Format Axis

Similarly, we will also change the Tick Marks for Minor Type to Inside for Horizontal-Axis and we will get the following output.

Fig 7 – Formatted Axis Output

Step 4: Format Chart Area

In this step, we will format the Chart Area. In order to make the chart look more enhanced and cleaner. For this Select Chart Area and then Right Click on it and select Format Chart Area. Please, make sure to click on Chart Area, not the Plot Area.

Fig 8 – Chart Area & Plot Area

Once we select the chart area and perform the above operation, excel will open Format Chart Area Pane.

Fig 9 – Format Char Area Options

In order to format the chart area pane, we are adding gradient color to our chart. For this go to Format Chart Area and then click on Fill & Line and select Gradient Fill.

Fig 10 – Gradient Fill

Once we choose Gradient fill option, excel will automatically fill the gradient color to our Chart Area. Similarly, we will also add the Gradient Fill to our Plot Area, and we will get the following output.

Fig 11 – Formatted Chart & Plot Area Output

Step 5: Format Chart Title

In this step, we will format the Chart Title. In order to make the chart look more enhanced and cleaner. For this Select Chart Title and then Right Click on it and select Format Chart Title. This will open the Format Chart Title pane on the right side of the spreadsheet.

Fig 12 – Format Chart Title

Using Format Chart Title, we are choosing the Gradient Fill option to fill gradient color to our chart title. Also, we will change the title to Sales Chart. After adding these changes, we will get the following output.

Fig 13 – Formatted Chart Title

Step 6: Format Data Series

In this step, we will format the Chart Data Series. In order to make the chart look more enhanced and cleaner. For this Select Chart Data Series and then Right Click on it and select Format Data Series.

Fig 14 – Format Data Series

This will open the Format Data Series pane on the right side of the excel spreadsheet. Using the Format Data Series, we will add a 3-D effect to our data series.

Fig 15 – Format Data Series

Once we add the 3-D effect to our data series we will get the following final output.

Fig 16 – Output