Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 - Are Users Experiencing Problems with Charts?
Has anyone experienced problems with charts created in Excel 2003 loosing
formatting when opened in 2007? So far these are the general problems I'm experiencing and I'm not sure if there's a solution, or if I should wait for the final release where these issues are hopefully corrected. 1. Full Charts created in Excel 2003 as separate sheets vs. embedded loose their formatting when opened in 2007, for example, the page size, page orientation, legend location, margins, axis alignments, all sometimes get munged up to some other setting. 2. When you try to edit the axes, sometimes you can't type into the text box to make the change. Every now and then I manage to edit the Axis titles, but I can't figure out how I did not. For now, I transfer the file to my other workstation which has Excel 2003 to format the charts. 3. When you try to publish multiple charts (as sheets) to PDF, sometimes the charts are printed incorrectly, like the first one will have the plot but the data points are all gone, another spreadsheet will have the entire plot zoomed out so you can no longer see the actual axes. However, the problems with publishing to PDF are consistently seen in the same Excel files. I also realize, I actually miss simply having the Right Click Chart Options dialogue box for configuring the Chart. If my imput counts, I would like to see that back. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 - Are Users Experiencing Problems with Charts?
These problems were very bad in Excel 2007 Beta 2. They were mostly fixed
up, but still less than satisfactory in Beta 2 Technical Refresh. We haven't seen the RTM version yet; I presume it will be better but still not quite perfect. You would be wise to think hard before upgrading, to make sure that you can still do what you need. Newer with more features does not always equate to better. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Cindy" wrote in message ... Has anyone experienced problems with charts created in Excel 2003 loosing formatting when opened in 2007? So far these are the general problems I'm experiencing and I'm not sure if there's a solution, or if I should wait for the final release where these issues are hopefully corrected. 1. Full Charts created in Excel 2003 as separate sheets vs. embedded loose their formatting when opened in 2007, for example, the page size, page orientation, legend location, margins, axis alignments, all sometimes get munged up to some other setting. 2. When you try to edit the axes, sometimes you can't type into the text box to make the change. Every now and then I manage to edit the Axis titles, but I can't figure out how I did not. For now, I transfer the file to my other workstation which has Excel 2003 to format the charts. 3. When you try to publish multiple charts (as sheets) to PDF, sometimes the charts are printed incorrectly, like the first one will have the plot but the data points are all gone, another spreadsheet will have the entire plot zoomed out so you can no longer see the actual axes. However, the problems with publishing to PDF are consistently seen in the same Excel files. I also realize, I actually miss simply having the Right Click Chart Options dialogue box for configuring the Chart. If my imput counts, I would like to see that back. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Controls in Charts? | Charts and Charting in Excel | |||
How can I make charts printable in a worksheet in Excel 2007? | Charts and Charting in Excel | |||
Printing embedded charts in Excel 2007 | Charts and Charting in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) |