G
Guest
I have a bar chart that represents the % of goal reached YTD. So for example
if the Goal is $100,000 for the year and January equaled $10,000 then the bar
graph would represent 10% of the goal met.
My problem or challange is in order to stay on track January should equal at
least $100,000 / by 12 (months) which would be 8,333.33. So in the example
above it should show on the bar chart past the first mark. Is there a way to
have the months show instead of percentages?
Also, once I create these charts I have to copy the entire worksheet,
including the charts to another worksheet. I have the entire worksheet using
formuals so I dont have to change anything other than the worksheet (tab)
name. Is there a way to do that for the chart as well?
Any help will be appreciated. Thanks.
if the Goal is $100,000 for the year and January equaled $10,000 then the bar
graph would represent 10% of the goal met.
My problem or challange is in order to stay on track January should equal at
least $100,000 / by 12 (months) which would be 8,333.33. So in the example
above it should show on the bar chart past the first mark. Is there a way to
have the months show instead of percentages?
Also, once I create these charts I have to copy the entire worksheet,
including the charts to another worksheet. I have the entire worksheet using
formuals so I dont have to change anything other than the worksheet (tab)
name. Is there a way to do that for the chart as well?
Any help will be appreciated. Thanks.