how to make a pie chart in excel without numbers

Now our quarterly chart looks a little bit better. A side bar will open in Excel for the formatting of the chart.Ĭlick on the Series Option. Right click on any column in the chart and click on format data series. So currently we have the clustered columns too apart from each other. But does this look meaningful? Na… So let's format it so that you can present this chart in a meeting. You have a chart that shows the sales done in different quarters in clustered regions.

Select the clustered column chart.Īnd it is done. Go to the Insert tab in ribbon.In charts group find 2D column chart. The report should look something like this. You can use a pivot report or formulated report. In this article we will learn how to create a sales column chart by quarters, with columns clustered by region.įrom the source data, prepare a report that shows the sales done in different regions in different quarters of the year. Creating a sales chart by region and quarter is an important task for any business analyst.

How to make a pie chart in excel without numbers