![]() ![]() Once the X-axis parameters are resolved, the data bars need to be formatted. To perform this, we need to delete the company’s multiple similar names and restrict them to a single entity in the data table. We can update it to a single company name record by keeping it at a middle portion and deleting the other records in the data table. In the X-axis, you can observe the multiple similar names of company in the chart it is because the no. ![]() Once the gap width is updated to 0%, the chart below mentioned changes could be observed. There is a gap between data series in the stacked bar chart we have to format it, where we need to remove the gap width across data bars, by clicking on anywhere in data bars, and right-click on it, in that select an option format data series, where we need to update the gap width percentage from 150 to 0% Now, once the 100% stacked bar chart is created, we have to format it. So, the total rows will be 100 rows data now, for this set of 100 rows, we have to create a 100% stacked bar chart under the 2d column chart option in the chart tab. For the company sun pharma, I have created 50 rows because the percentage share is 50, a similar number of rows is created based on the percentage sales of each company so, the total hundred rows created, after this, I have to add the respective company distribution share for each company across different rows. Once we get the percentage sales of sales data for each company, to create a mekko chart, we need to create that many rows for each company, i.e. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |