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.

Q2: If I understand correctly: hold the CTRL key and drag the worksheet's
tab to the right to make an exact copy. Now rename the worksheet.

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jordan" wrote in message
...
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.