how to make a pie chart in excel with your own data

HOW TO MAKE A PIE CHART IN EXCEL WITH YOUR OWN DATA HOW TO
HOW TO MAKE A PIE CHART IN EXCEL WITH YOUR OWN DATA FULL
HOW TO MAKE A PIE CHART IN EXCEL WITH YOUR OWN DATA SERIES

For now we have only one chart template here. Here you have all your saved chart templates. Here on the top, you will see a folder named templates.

Here excel will show some recommended charts for your data. We can use the same chart we created for the sales and productivity analysis. Now this data is different from the data we used earlier but the structure is same. Now I have a new data of salesmen and the average sales in different years.

HOW TO MAKE A PIE CHART IN EXCEL WITH YOUR OWN DATA HOW TO

How to Use a Saved Chart Template in Excel? You can change if you want.Ĭlick on the save button. The default location of chart templates is Microsoft/Templates/charts. The save filter is set to Chart Template File. The above step will open a save as dialog box. Step 2: Name and Save the chart template at desired location.

To save this chart as chart template follow these steps:ġ: Right click on the chart and click on the 'Save as Template.' option. How to save the custom chart as template in Excel? In that case I will save this chart as template and use it whenever I want it. Now if I have to create this chart with some different data, I may not remember what I had did (most of the time I forget). I have done several formatting to create this chart. Now I have this chart that suits my dashboard. I am sure you will do your own formatting. Done some more foramating that you can see in the below image. I increased the width of the columns by reducing the gap width between them. Added the chart title as 'Sales and Productivity'.

I colored the background of the chart too. I colored the columns and line in the chart in shades of purple from the format option of the chart. We have a chart that looks like this and tells more story than the default chart.įormat the chart as per the theme of dashboard:

HOW TO MAKE A PIE CHART IN EXCEL WITH YOUR OWN DATA SERIES

Change the chart type for productivity series to line with markers. Here, click on secondary axis check box for productivity series. Right click on the chart and click on the change chart type option. We definitely need to edit and customize it to our needs. The chart does not have any theme or appeal. The productivity columns can't be seen clearly as they are too small as compared to sales. Now this default does not represent the data accurately. Or you can go to insert-> charts and insert a chart of your choice. Now select this data, and press the CTRL+F1 to shortcut to insert a default embedded chart in Excel. Here we have a data of sales and productivity of a department in different months. So, first we need to create a chart template.

In this article, we will learn how to create a custom chart and save them as an Excel chart template. In that case we, create an Excel custom chart and same save them as Excel Chart Templates to use them later in reporting. We can do the customization of chart manually if it is one time task but it is not smart to do same customization of charts again and again.

HOW TO MAKE A PIE CHART IN EXCEL WITH YOUR OWN DATA FULL

Sometimes because they need to match the theme of the dashboard or presentation and sometimes because the default Excel charts does not full fill the requirement. But most of the time user needs to customize the charts. Excel charts can display complex data in easiest ways and user can get meaningful information from it.Įxcel charts have many chart template that are sufficient to visualize most of the data. An Excel chart is excellent tool for visualizing data.

How to make a pie chart in excel with your own data