Start Updating category axis excel

Updating category axis excel

Before you get started, you should have a chart inserted in your Power Point slide -- we use a Column chart for this example.

In Part 3 of this Monte Carlo Simulation example, we iteratively ran a stochastic sales forecast model to end up with 5000 possible values (observations) for our single response variable, profit.

For Example if you were to write a date function as =DATE(2009,13,1) it would give you a date 13 months ahead of 1-Jan-2009. is the portion representing the day part of the date that we are trying to construct.

Again, just like the month parameter mentioned above, the day is not limited to numbers lying between 1 and 31 but can be any number (negative or positive) till such time that the minimum and maximum limits for the date, as mentioned above, are not breached.

After you have created a chart in Excel, what's the first thing you usually want to do with it?

Make the graph look exactly the way you've pictured it in your mind!

For Example if you were to write a date function as =DATE(2009,4,35) it would give you a date 35 days ahead of 1-Apr-2009. Similarly you could use a negative number generate a date in the past.

(You can even enter fractions though that would not be much use.) Let’s us take a look at an example of the DATE formula. Then enter the month in which the date we are trying to create occurs.

Let's start with changing Vertical (Value) axis labels: Have your ever used keyboard shortcuts and sequences in Power Point? Go and get a copy of our Power Point Keyboard Shortcuts and Sequences E-Book.