| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
using office 2007 chart in office 2003
I have created a Line chart using Excel 2007 in compatibility mode. When I
open the workbook using Excel 2003 it does not know the chart sub-type, and when the chart is regenerated by my macro it defaults to 'Line with markers displayed at each data value'. I need to distribute my chart to users running Office 2003, and I need the chart to retain the original chart type. Any ideas please? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
using office 2007 chart in office 2003
The rule of thumb if your workbooks are to be shared with users of
different Excel versions, is to create your workbook in the oldest version that any of the users has. Unfortunately Compatibility Mode doesn't really mean Excel 2003. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Bertie wrote: I have created a Line chart using Excel 2007 in compatibility mode. When I open the workbook using Excel 2003 it does not know the chart sub-type, and when the chart is regenerated by my macro it defaults to 'Line with markers displayed at each data value'. I need to distribute my chart to users running Office 2003, and I need the chart to retain the original chart type. Any ideas please? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
using office 2007 chart in office 2003
I have got around the problem by resetting the chart type from within my
macro, so it now works correctly on both 2003 and 2007. "Jon Peltier" wrote: The rule of thumb if your workbooks are to be shared with users of different Excel versions, is to create your workbook in the oldest version that any of the users has. Unfortunately Compatibility Mode doesn't really mean Excel 2003. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Bertie wrote: I have created a Line chart using Excel 2007 in compatibility mode. When I open the workbook using Excel 2003 it does not know the chart sub-type, and when the chart is regenerated by my macro it defaults to 'Line with markers displayed at each data value'. I need to distribute my chart to users running Office 2003, and I need the chart to retain the original chart type. Any ideas please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I import an Office 2007 file into Office 2003? | Excel Discussion (Misc queries) | |||
| Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
| Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
| Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
| Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
