Solved

# Forecast data based on Parato chart

Posted on 2010-09-15
376 Views
Hi Experts,

I would like to request Experts help. How  to incorporate 20% of increase for each year (2011,2012 and 2013) based on average rate in the attached chart and need to differentiate the exciting and forecast value clearly. Is that possible to create a pareto chart to show this 20% increment for these forecast year? Hope Experts could help me to create this chart.

Chart-Parato.xls
0
Question by:Theva
• 3

LVL 50

Expert Comment

ID: 33680307
Hello Theva,

maybe something like this?

cheers, teylyn
Chart-Parato.xlsx
0

LVL 50

Expert Comment

ID: 33680320
or this version, with the increase calculated as 20% of the average.

cheers, teylyn
Chart-Parato-v2.xlsx
0

LVL 50

Accepted Solution

teylyn earned 300 total points
ID: 33680390
third time lucky. I mixed up the price and quantity data in the previous two charts. Sorry. See this for a better approach.

cheers, teylyn
Chart-Parato-v3.xlsx
0

LVL 12

Assisted Solution

tilsant earned 200 total points
ID: 33680433
Hi Theva,
May be you can also use/show the values from the FORECAST worksheet function.

Also, in case if you need to change the 20% to a different value then just change the value in cell A6.

Tils.

Copy-of-Chart-Parato.xls
0

Author Closing Comment

ID: 33683451
Hi Teylyn/Tils:

Thanks  for the brilliant chart, simply amazing.
0

## Featured Post

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…