Chart showing actuals vs 3 targets

**cell-dweller** · 08-05-2010, 06:23 PM

I am trying to show a "actual" daily amount in a chart against the 3 targets set. The 3 targets set make up an amount in %, so i would like to show the actual as a percentage (to the normal target, not min or stretch)
Is this possible? I have attached a sheet of what i have so far, but just need to get my "actual" total on the sheet showing how far i have to go, or how much i still need to do.
Any help appreciated.
Thanks

**Palmetto** · 08-05-2010, 09:55 PM

See if the attached is what you need.
Your original chart was changed to a clustered column type and then by formatting the series and adjusting the overlap and gap width followed by sequencing the series order so that columns lined up correctly one behind the other.

Another chart was added, combination line/column which, IMO, is a better choice to present the targets and show actual attainment. Additional data points for the targets were added in order to plot lines.

The x-axis scale was turned off to give the chart a cleaner appearance.

**cell-dweller** · 08-09-2010, 06:27 PM

Thanks Palmetto. That looks great. Any way you can work this with percentages?

**Cheeky Charlie** · 08-09-2010, 06:40 PM

Thoughts:
You wanted to show things as percent of target, and you want target to be 100% with stretch going up to 200% - so your original graph y axis is wrong, right? To get the axis right you would need to create replica series doing the division for the percentages - this also applies to your follow up question above, but I'm not sure exactly what you want...
I didn't like what you had on row 13, would =SUMIF($G2:$G12,"<>",B2:B12) work a bit better?
Are you looking for a single bar which compares to three targets, or a timeline of performance against three targets? Obviously Palmetto has provided the latter, I had guessed you wanted the former...

**cell-dweller** · 08-10-2010, 12:00 AM

Hi Charlie, Not sure what the formula is, but it makes the sum 40 in column G. Is this your intention?
I was thinking, like you said that target is 100% and stretch is 200% (or can it be 150%)?
This way i can see a % to target, and what is left to reach either target or stretch goal.
Does this make sense?

**Cheeky Charlie** · 08-10-2010, 03:44 AM

It calculates the cumulative targets for the days completed (you had a sum which went to half-way down the 'targets' columns.
Your targets can be whatever you darn well want, isn't Excel fabulozo?
Kind of, but:
Are you looking for a single bar which compares to three targets, or a timeline of performance against three targets? Obviously Palmetto has provided the latter, I had guessed you wanted the former... or something else?