Excel Chart with percentages

**fiorella1985** · 07-27-2012, 10:14 AM

Hi All,

I need a chart that shows Actual numbers, goals but in the Y axis shows percentages to Goal numbers instead of the Actual numbers. Anyone can suggest a way to show it?

Thanks,
Fio

**Andy Pope** · 07-27-2012, 10:32 AM

You can fake the axis to display goal percentage.

I have added 2 xy-scatter lines to the chart for the axis and the goal line.

Use this free addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

**fiorella1985** · 07-27-2012, 11:12 AM

Thanks for your Reply Andy. What if I want the goal to be a column instead of a line in the same graph?

Thanks,
Fio

**Andy Pope** · 07-27-2012, 11:14 AM

Change the chart type for that series to column.

**Andy Pope** · 07-27-2012, 11:19 AM

In fact if you calculate the chart values you can do away with the dummy axis series.

**fiorella1985** · 07-27-2012, 11:21 AM

Thanks it works!

**Cutter** · 07-27-2012, 11:49 AM

@ fiorella1985

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.