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.
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.
By doing this, Excel will automatically insert a column chart for our dataset.
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.
Once we click on Format Axis option, Excel will automatically open a Format Axis Pane.
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.
Similarly, we will also change the Tick Marks for Minor Type to Inside for Horizontal-Axis and we will get the following 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.
Once we select the chart area and perform the above operation, excel will open Format Chart Area Pane.
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.
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.
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.
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.
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.
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.
Once we add the 3-D effect to our data series we will get the following final output.
Please Login to comment...