Take the 2-minute tour ×  Here is my problem today. I have a
revenue (4M) and a rebate for each of the twelve months (a chart
with 12 lines). My total rebate is the sum of the 12 rebates.
Until there, no problem.  However, I would like to do a
simulation and thus do a chart with 11 different values (revenue
ranging from 3M to 5M) in order to see how the rebate would
change. Here comes the problem, I would like to avoid having a
12 lines chart for each of my lines in my simulation chart.  Is
there any way to do this on Excel (without using VBA).  Thank
you very much for your help  share|improve this question I am
confused. Are you using a ratio to determine what the simulated
rebate would be? –  Pynner Feb 6 '12 at 21:10 exactly. I would
like to do a chart with different values of revenues, and for
each revenue i'd get a different rebate. I would like to
automatize it in other words –  SammyDow Feb 7 '12 at 8:44 add
comment  1 Answer  A relatively easy way to get where you want
to go is to create your simulati