Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

213460 - 2007: How to Programmatically Print All Embedded Charts on a Worksheet

Knowledge Base Articles - 2003

077241 - 2003: Creating charts with multiple groups of stacked bars

Knowledge Base Articles - 2002

291208 - 2002: Application.Dialogs(xlDialogChartWizard).Show Fails on PivotChart

199201 - 2002: Cannot Move or Resize Chart Objects in a PivotChart

296665 - 2002: Data Labels Do Not Retain Formatting

811161 - 2002: Data labels disappear if value is greater than axis maximum in Excel 2002 and in Excel 2003

821078 - 2002: Excel Quits When You Draw a Connector Line on a Chart

323613 - 2002: GRAPH.EXE - Application Error' error message when you delete multiple columns from a graph

214265 - 2002: How to Create a User-Defined Chart Format

815196 - 2002: Labels in Pasted Excel Chart Object Are Distorted Unreadable or Incomplete

300643 - 2002: Macro to extract data from a chart in Excel

277593 - 2002: Scatter Chart Series Lines and Trendlines Are Not Printed Correctly

214332 - 2002: Text Is Truncated in Text Box on Chart in Worksheet When Printed or Previewed

213447 - 2002: Visual Basic Module to Create a Gantt Chart

Knowledge Base Articles - 2000

200078 - 2000: #N/A Chart Label Issues

273657 - 2000: 3-D Column Chart Doesnt Appear As Full As Expected

213958 - 2000: Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000

213921 - 2000: Add Totals to a Stacked Column Chart in Excel 2000

214292 - 2000: Add a Series to an XY (Scatter) Chart with a Second X-Axis in Excel 2000

214293 - 2000: Area Charts Ignore 'Empty Cells Plotted As' Setting

212229 - 2000: Background Turns Black When You Paste an Object into the Floor of a 3-D Chart

248175 - 2000: Border Color of Lines Returns Incorrect RGB Value When Border Color Is Set to Automatic

215945 - 2000: Cannot Change Chart to PivotChart

211650 - 2000: Cannot Change Fill Color for Walls or Floor on 3-D Chart

214312 - 2000: Cannot Change Series Colors on a Surface Chart

221041 - 2000: Cannot Select Part of PivotTable as Source for Chart

211691 - 2000: Cannot Undo Background in Text Box on a Chart Object

213653 - 2000: Cannot Use Array as Source Argument with SeriesCollection

213687 - 2000: Cannot Use Array of Data Points with Extend Method

214343 - 2000: Category Axis Labels May Appear Twice in Chart

265018 - 2000: Cell Formulas Change When You Copy a Worksheet with an Embedded Chart

214389 - 2000: Certain Trendlines in Charts Are Displayed Incorrectly

213881 - 2000: Change the Chart Type of a Series in a Combination Chart in Excel 2000

231110 - 2000: Changing Chart Title in Chart Options Dialog Box Resets Font Formatting

211942 - 2000: Changing the Chart Type Changes X-Axis

212119 - 2000: Chart Axis Changes Scale in Earlier Version of Workbook

214348 - 2000: Chart Axis May Be Four Years Early After You Format Scale

211559 - 2000: Chart Data Table Does Not Display All Data Points

211606 - 2000: Chart Is Reduced to a Small Size After Formatting the Legend

214232 - 2000: Chart Labels Print Inside a White Box

215159 - 2000: Chart Object Resizes After Switching to Another Program

211940 - 2000: Chart Series Does Not Use Removed Secondary Axis Scale

199542 - 2000: Chart Titles with Multiple Lines Display Only One Line

248202 - 2000: Charts Lose Axis Labels Axis Scaling After You Copy Worksheet

115341 - 2000: Column Charts May Not Show All Data Labels

214290 - 2000: Column Charts May Not Show All Data Labels

211409 - 2000: Column and Area Chart Y Axis Is Scaled in Microsoft Excel 2000

211614 - 2000: Columns Are Transparent When They Are Printed in Black and White

211476 - 2000: Copied and Pasted Chart Appears as Gray Rectangle

248223 - 2000: Dashed Series Lines Appear Solid in Excel 2000

214378 - 2000: Data Labels Change Position in a Chart

239846 - 2000: Data Labels Misplaced with Bar Charts

213888 - 2000: Data Labels on Chart Appear Outside the Plot Area

213980 - 2000: Data Map Charts Use Hidden Rows and Columns

131731 - 2000: Data Map Charts Use Hidden Rows and Columns

211767 - 2000: Dates Made Consecutive When Charting in Microsoft Excel

211609 - 2000: Drawing Objects Are Not Saved on User-Defined Chart

211739 - 2000: Embedded Chart Size Changes When Copied and Pasted

257713 - 2000: Embedded Excel Chart Resizes in Word When Scrolling to Different Page

257622 - 2000: Embedded Excel Chart Resizes in Word if Zoom is Set to 20% or Less

211436 - 2000: Error Appears When Changing Chart Location with a Macro

215900 - 2000: Error Changing Chart Source from Worksheet Data to PivotTable

211953 - 2000: Error Message When Editing Chart Linked to Closed Workbook

234682 - 2000: Error Message: Cannot Place Chart on a Hidden Sheet

213379 - 2000: Error Programmatically Accessing Data Series on a Chart

221489 - 2000: Error Publishing Chart with Data from Multiple Sheets

213695 - 2000: Error Setting AxisGroup Property of Series Class

211568 - 2000: Fonts on Chart Title and Label Are Too Large

214240 - 2000: Glossary of Charting Terminology

214075 - 2000: How Chart Axis Limits Are Determined

213644 - 2000: How to Automatically Set Min and Max Scale for Y-Axis

214139 - 2000: How to Break Links Between a Chart and a Worksheet

213729 - 2000: How to Change the Taper Style for All Series in a Chart

213930 - 2000: How to Create a Bell Curve Chart

213351 - 2000: How to Create a Chart with Non-Contiguous Ranges

213780 - 2000: How to Use Visual Basic to Create a Dynamic Chart

213521 - 2000: How to Use the ApplyCustomType Method to Format Charts

214119 - 2000: How to create charts with multiple groups of stacked bars in Excel 2000

213750 - 2000: How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel

211958 - 2000: Illegal Operation Error if Chart Gallery File Is Password-Protected

237884 - 2000: Incorrect Range of Values Displayed on X-Axis of XY (Scatter) or Bubble Chart

259625 - 2000: Invalid External Reference Error When Creating Chart

236298 - 2000: Labels on X-Axis of XY (Scatter) Chart Distorted When Rotated 90 Degrees

262113 - 2000: Labels on XY Scatter Graphs Disappear in Print Preview

258843 - 2000: Layout of Vertical X-Axis Labels in Column Chart Is Distorted When Copied to Clipboard

211752 - 2000: Left Top Sides of Chart Missing After Pasting Bitmap Picture

264517 - 2000: Linked Charts Lose Custom Colors When You Update Source Data

249060 - 2000: Linking Charts Does Not Work Correctly If Name Has More Than 64 Characters

214317 - 2000: Moving Average Period Reduced by 256 After You Save the File

235429 - 2000: Multiple-Level Category Labels Displayed Differently in Excel 2000

211689 - 2000: New Text Box Created When Text Box in Chart Linked to Cell

211663 - 2000: Objects in Chart May Not Appear in Sample Chart

211823 - 2000: Page Fault When You Add a Shadow to a Series in a Surface Chart

232878 - 2000: Polar Charts Are Available in Microsoft Office Chart Component

218986 - 2000: Problems Using Code to Display ChartWizard on PivotTables

206369 - 2000: Published Chart Displays 'Series' as Name in Legend

214318 - 2000: Series Data Orientation Not Saved in Custom Chart Type

274531 - 2000: Series Order Is Reversed When Chart Type Is Changed to 3-D

268524 - 2000: Server Application Cannot Be Found When You Open Embedded Excel Object

211960 - 2000: Setting Default and User-Defined Chart Types

247578 - 2000: Symbol Bitmaps Not Displayed and Excel Quits Unexpectedly After Copy and Paste on Chart

211728 - 2000: Trendline Equation Label Does Not Use the Specified Color

214025 - 2000: Trendlines Unavailable for Area Chart Type

215307 - 2000: Undoing Change to Chart after Freezing Pane Causes Invalid Page Fault

211677 - 2000: Unexpected Font or Color Formatting Applied to Chart

213575 - 2000: Using a Macro to Activate a Chart Changes the Selection

213443 - 2000: Visual Basic Macro to Break Chart Links

210766 - 2000: X and Z Axis Labels Appear to Be Reversed in a 3-D Pivot Chart

283017 - 2000: XY Scatter Chart Distorted If You Change XY (Scatter) Chart Axes

212209 - 2000: You Are Unable to Create a Transparent Chart Area

Knowledge Base Articles - 1997

157539 - 1997: 'Features May Be Lost' Message Appears When Saving File with a Chart

172948 - 1997: 'Not Enough Memory' Opening a Workbook with a Chart

115768 - 1997: 'Reference is Not Valid' Error with Lotus 1-2-3 Chart

111354 - 1997: 1-2-3 Commands to Attach Text Data Labels to a Chart

200816 - 1997: 3-D Surface Chart Lines May Not Follow Slope of Data

115073 - 1997: Adding Series to XY (Scatter) Chart with Second X Axis

111957 - 1997: Area Charts Ignore 'Empty Cells Plotted As' Setting

157826 - 1997: Background Turns Black Pasting Object in 3-D Chart Floor

155205 - 1997: Cannot Add a Data Table to Some Charts

175699 - 1997: Cannot Change Fill Color for Walls or Floor on 3-D Chart

174447 - 1997: Cannot Change Gridlines on Surface Chart

109575 - 1997: Cannot Use Array as Source Argument with SeriesCollection

166672 - 1997: Certain Trendlines in Charts May Appear Distorted

082015 - 1997: Changing Series Colors on a Surface Chart

161660 - 1997: Changing the Chart Type Changes the X-Axis

170088 - 1997: Chart Axis Changes Scale Opening Earlier Version Workbook

177172 - 1997: Chart Axis May Be Four Years Early After You Format Scale

171999 - 1997: Chart Border Is Too Large or Small After Using Paste Link

182999 - 1997: Chart Data Labels That Are Linked to Formulas Are Not Updated

161929 - 1997: Chart Data Range Disappears After Changing Series

156978 - 1997: Chart Data Table Does Not Display All Data Points

161731 - 1997: Chart Display Options Change According to Page Setup

157598 - 1997: Chart Elements Are Resized When Workbook Is Saved

154959 - 1997: Chart Embedded on Chart Sheet Does Not Preview

185001 - 1997: Chart Exported as a Graphic File May Be Truncated

186931 - 1997: Chart Is Reduced to a Small Size After Formatting Legend

156890 - 1997: Chart Opens More Slowly than in Earlier Versions

161664 - 1997: Chart Series Doesnt Use Removed Secondary Axis Scale

185392 - 1997: Chart Titles with Multiple Lines Display Only One Line

161006 - 1997: Chart Trendline Formula Is Inaccurate

178181 - 1997: Chart Truncated After Performing Paste Link Operation

172098 - 1997: Chart in Worksheet Resized After Pasting into Word

168364 - 1997: Charts.Delete Command in Macro May Delete Worksheets

174170 - 1997: Column and Area Chart Y Axis Is Scaled in Microsoft Excel 97

181093 - 1997: Columns Missing from Chart on Printout

161218 - 1997: Copied and Pasted Chart Appears as Gray Rectangle

161438 - 1997: Crash When Chart Gallery File Is Password Protected

125178 - 1997: Creating Non-Default Text Labels on an XY (Scatter) Chart

168582 - 1997: Custom Chart Types May Appear Distorted

248794 - 1997: Dashed Series Lines Appear Solid in Excel 97

239830 - 1997: Data Labels Misplaced with Bar Charts

170089 - 1997: Dates Made Consecutive When Charting in Microsoft Excel

186678 - 1997: Drawing Objects Are Not Saved on User-Defined Chart

171660 - 1997: Editing Chart Object Causes Illegal Operation

170760 - 1997: Embedded Chart Changes Size When Copied and Pasted

172639 - 1997: Error Activating Chart Not on the Active Worksheet

169250 - 1997: Error Appears When Changing Chart Location with a Macro

161474 - 1997: Error Editing Chart Linked to Closed Workbook

173055 - 1997: Error Formatting Chart Data Label Border

170794 - 1997: Error Message Appears Creating Custom Chart Type

169177 - 1997: Error Message Appears Formatting Chart Data Labels

172278 - 1997: Error Message Appears Returning MSGraph Object Name

139327 - 1997: Error Programmatically Accessing Data Series on Chart

171076 - 1997: Error Setting AxisGroup Property of Series Class

165569 - 1997: Error When Copying Chart Objects to Other Programs

157770 - 1997: Error When Dragging Embedded Chart into Microsoft Word

172461 - 1997: Error or Chart Disappears When You Open a Lotus WK4 File

186219 - 1997: Excel Quits Unexpectedly Running Macro That Creates Chart

171313 - 1997: Exploded Slice of 3-D Pie Chart Appears Incorrectly

156894 - 1997: Fonts on Chart Title and Label Are Too Large

101939 - 1997: How Chart Axis Limits Are Determined

157940 - 1997: How To Create a Dynamic Chart Using Visual Basic

137528 - 1997: How to Add Text to the X or Y Axis on a Chart

168253 - 1997: How to Change the Depth of a 3-D Surface Chart

162092 - 1997: How to Change the Taper Style for All Series in a Chart

163103 - 1997: How to Create a GIF File from a Microsoft Excel Chart

161670 - 1997: How to Plot Values Against a Recommended Range

169882 - 1997: How to Rename a Chart Using Name Box

141103 - 1997: How to Reverse the Axis on a Bar Chart

161858 - 1997: How to Trap Events for an Embedded Chart

167279 - 1997: How to Use the ApplyCustomType Method to Format Charts

157354 - 1997: How to View Sample Chart with the Keyboard

166987 - 1997: Illegal Operation Error Using ListBox Control

163049 - 1997: Illegal Operation Using Chart Wizard

108369 - 1997: Inconsistent Results Moving Chart Data Labels

159832 - 1997: Inserting Second Trendline into Chart Halts MS Excel

170585 - 1997: Left Top Sides of Chart Missing After Pasting Bitmap Picture

168237 - 1997: Line Chart with Smoothed Line Selected May Cause Error

175356 - 1997: Microsoft Graph Object Displayed Differently in Excel 97

150686 - 1997: Moving Text Box on Chart Causes Chart to Grow

172857 - 1997: New Text Box Created When Text Box in Chart Linked to Cell

160099 - 1997: Nothing Is in Printout of Embedded MS Excel Chart

173949 - 1997: Objects in Chart May Not Appear in Sample Chart

161530 - 1997: Overview of the Built-In Chart Types

168953 - 1997: Page Fault Adding Shadow to Series in Surface Chart

172258 - 1997: Page Fault Running Macro That Adds Chart to Worksheet

172412 - 1997: Page Fault Setting ProtectGoalSeek Property of Chart

169251 - 1997: Page Fault Viewing Chart in Print Preview

172321 - 1997: Page Fault When Formatting a Series in a Chart

177528 - 1997: Pie Chart Slices Dont Match Legend in Printout

157110 - 1997: Problems When Selecting Error Bars With a Macro

272716 - 1997: Radar Chart Shrinks After Print Preview

136088 - 1997: Salmon Colored Lines Not Printed

168965 - 1997: Scrolling in Chart Causes Text Boxes to Disappear

161348 - 1997: Setting Default and User-Defined Chart Types

171234 - 1997: Trendline Equation Label Uses Different Color

116057 - 1997: Trendlines Unavailable for Area Chart Type

160609 - 1997: Unable to Create a Transparent Chart Area

173077 - 1997: Unexpected Font or Color Formatting Applied to Chart

157558 - 1997: Using a Macro to Activate a Chart Changes the Selection

190359 - 1997: Value (Y) Axis Labels Missing When Workbook Is Reopened

124232 - 1997: Visual Basic Macro to Break Chart Links