Updating category axis excel dating and the n game

Rated 4.14/5 based on 866 customer reviews

Visit Stack Exchange I have a time series of values and corresponding dates, continous but not with equal interval.I have created the graph and chosen the "date" column as x-axis but it is not registered.In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically. Select the data range and click Table under Insert tab, see screenshot: 2.In the Create Table dialog box, if your data has headers, please check My table has headers option, then click OK. And the data range is formatted as a table, see screenshot: 4.

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

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..).

Let us take an example of a Hotel for which the complaints data could look something as shown below: This Pareto chart highlights the major issues that the hotel should focus on to sort the maximum number of complaints.

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

Leave a Reply