Shopping Basket: (0) View Basket
Welcome Guest [Login | Register]
Last Date for a Chart

Sometimes you may need to change the date on an axis to a specific day / month, you may use the following method:

Last Date for a Chart

• Click on the axis > Format axis, select General for the Category under the Number tab

Get the General Code

• Remember the last date shown on the axis

A Simple Calculation

• Click on the axis > Format axis, select Custom for the Category under the Number tab, and enter [=X]“Y”;Z   (in this case [=40263]"3/31/10";m/d/yy)
That means if the value of the axis = X, show Y, and the other value follow the formula Z

Edit the Last Date

And it is done!

It's done!

Same technique can be applied to the y-axis too.

Broken Scale Chart

- End of Tutorial


Products: 252 Categories: 64 Prices: US Dollars
Ultimate Pres is PayPal Verified website security





© 2012 Ultimate Pres | PowerPoint Templates. All rights reserved.