Updating category axis excel

Rated 3.99/5 based on 660 customer reviews

Supposing you have created a chart to track the daily sales based on a range of data in your workbook.But you need to change or edit the number of the data every day, in this case, you have to update the chart manually so it includes the new data.Pareto Chart is based on the Pareto principle (also known as the 80/20 rule), which is a well-known concept in project management.According to this principle, ~80% of the problems can be attributed to about ~20% of the issues (or ~80% of your results could be a direct outcome of ~20% of your efforts, and so on..).

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

On your chart, double click on the values of your x-axis and it will open up a new window - Format axis Format axis: Then you can check the format to show the dates.

Might be a formatting thing as I tried and it automatically showed the dates on the x axis.

For example, targeting the first 3 issues would automatically take care of ~80% of the complaints.

Now that we have a static/simple Pareto chart in Excel, let’s take it a step further and make it a bit interactive.

Leave a Reply