eaglekepr

Well, my small office just converted from Office 2003 to 2007 and me being "the computer guy", I have to figure out the differences because people expect me to teach them (btw, I'm not IT... I do know where the power button is, that's why I was picked). My small office uses a slide show for monthly stats, that has about 50 or so charts that were created in MS Graph under Powerpoint 2003. I realize that you can continue using those same charts as objects in 2007, but it asks you EVERY time if you want to convert them when opened. Eventually, they'll need to be converted, but in playing around with them, using an Excel spreadsheet loses some functionality you had in MS Graph. Specifically: Our charts use a rolling month bar graph ("Apr May Jun...Jan Feb Mar"). When the slides are updated for the next month, in MS Graph we have been double-clicking last year's month/column off the chart (dims the column but doesn't dump the data) and adding the new month to the end. Click outside the data box and you're done. Using Excel 2007 doesn't seem to have a method to do that. I can HIDE the old month's column from the spreadsheet, but if I add the next month to the end (for example next months slides I'd hide the old "Apr" and add a new "Apr" to the right side of the spreadsheet) it doesn't allow me to have a second "Apr" column. It automatically renames the column "Apr2". The only way I can see to not have the 2 added on is to DELETE last year's column and therefore lose the data. What's the best method of using charts in 2007 while allowing me to hide and add columns like in 2003? IS there a method? I COULD tell everyone to just keep pressing the "Edit Existing" button when the edit a chart, but eventually someone is going to accidentally or, not-caring, click convert and then we're stuck with it.