Hi

Depending on your chart you would be better off setting up a conditional
chart. Create a second set of columns that displays the hashed data.
Combine this with a dynamic named range and you will not need to format
you chart every month.
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

belohls wrote:
In excel graphs - bar charts, I make the last bar a hashed shading as it is a
forcast. To do this I select only the last bar and change its formating. At
the end of the month I want to change the format back to the same as all the
other bars and make the new coming month's predicted value that hashed
shading etc.

Unfortunately excel will not allow copy and paste in this situation - so I
have do open the format tab etc and then change.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info