Home > Excel Help Portal > Excel Charts

<<  (Page 2)  Previous              Next  (Page 4)  >>

Excel Charts

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses using charts in Microsoft
Excel.

101. How to add Totals to a Stacked Column Chart in Excel 2000 This step-by-step article shows you how to add total values to a stacked column chart in Microsoft Excel 2000. In Excel, you can add data labels that automatically display the values of an individual series in a stacked chart. You can... KB#213921. Keywords: Charts, Legend, SERIES, Borders, Patterns, RIGHT

 
102. Maximum Times in Microsoft Excel In Microsoft Excel, there are limits to the maximum time values that you can enter into a cell or return by using a formula. This article explains those... KB#214386. Keywords: SERIES, Dates, Format, Formulas

 
103. How to add a Series to an XY (Scatter) Chart with a Second XAxis in Excel 2000 When you add a second series to an XY (scatter) chart, the new values are added with respect to the same x-axis values as the first series. This step-by-step article explains how to add a second series to an XY (scatter) chart that uses a second... KB#214292. Keywords: Charts, SERIES, Format

 
104. Leave Chart Corner Blank in Excel The solution is incredibly simple. I asked Mark if he had a title in the upper left corner of his chart data. Like the example shown, he did. If you can re-arrange your data so that this upper left cell of the chart data is blank, (in the example at the right, I moved the work "Census" up one... Keywords: Charts, SERIES, Years, VBA, Web

 
105. How to Obtain the Excel 97 Auto Recalculation Patch In Microsoft Excel 97 and Microsoft Excel 97 Service Release 1 (SR-1), worksheet values may not be recalculated correctly when certain conditions are true. To correct this problem, Microsoft has developed the Excel 97 Auto-Recalculation Patch for... KB#174868. Keywords: Charts, Download, Formulas, Files

 
106. How to Break Links Between a Chart and a Worksheet In Microsoft Excel, a chart can be unlinked from its corresponding worksheet by converting the references in the series formula to values. To convert all the references in the series formula to values, follow these steps: Make sure both documents... KB#214139. Keywords: Charts, SERIES, Errors, Formulas, Links

 
107. Group Object Containing Excel Object Changes Size When OleFormat.DoVerb Opens Excel Object In a PowerPoint 2000 presentation, if you create an object group that contains a Microsoft Excel chart object and another object, and you run a macro that uses the DoVerb method to open the Excel chart object, the size of the group object... KB#257428. Keywords: Charts, Format, Macro, Object, VBA

 
108. Removing external links I have tried the German version. It is only 20KB versus the 168KB of the Microsoft version. It is a very simple add-in and doesn't have the bells and whistles of the other one. However it clears the error message I found with the MS one. It also clears links very simply as well. How it works:A... Keywords: Add-In, Charts, SERIES, Download, Errors, Links, VBA, Error Message, Files, Web

 
109. Gantt Chart Sample AddIn Available for Download The Gantt Chart Sample Add-in is a sample COM add-in designed for use with Microsoft Excel. The purpose of this sample is to illustrate how to create a COM add-in using the Add-in Designer with Microsoft Visual Basic 6.0. The following file... KB#254008. Keywords: Add-In, Charts, GANTT, Download, Colors, Format, VBA, Files, Templates

 
110. How to create a Single Stacked Column Chart or Single Bar Chart in Excel 2000 This step-by-step article explains how to create a single stacked column chart and a single bar chart in Microsoft Excel 2000. these kinds of charts. Create Stacked Column Chart To create a single stacked column chart, follow these steps: Start... KB#213929. Keywords: Bar Chart, Charts, Legend, SERIES

 
111. Expanding a chart by dropping new data onto the chart Here is a cool & easy charting tip for those of us who must re-do charts each week, month, quarter or year to reflect a new data point. Return to the Mr Excel Home Page. Thanks for visiting Mr Excel.com! Proudly serving the web since November 21, 1998. You are visitor # . Originally published April... Keywords: Charts, SERIES, Months, Sales, Borders, Format, Patterns, Errors, Printing, VBA, Web

 
112. Excel Quits Unexpectedly When You Switch Between Tab Strip and Chart on Worksheet If you insert a Microsoft Forms 2.0 TabStrip control and a chart on a worksheet, and you click between the control, the chart, and the cells on the worksheet, Excel quits unexpectedly, and you receive an application error... KB#320520. Keywords: Charts, Dates, Errors, Error Message, File Name, Files

 
113. Naming a Chart A common question people have is "How can I name an Excel chart?" When using VBA, you can activate a chart by name, but charts just get a default name like "Chart 3" or "Chart 88", in the order in which they are created. A recorded macro will capture that sequential name, but it's no good when you... Keywords: Charts, Formulas, Macro, Object, VBA

 
114. How to Reverse the Axis on a Bar Chart When you create a bar chart with the ChartWizard, the category labels are arranged from bottom (the first label) to top (the last label) instead of from top to bottom as expected. This order of arrangement occurs because labels are plotted from... KB#141103. Keywords: Bar Chart, Charts, Format

 
115. SR1 Stops Responding When You Open a File After an Incomplete Save When you try to save a workbook that contains charts, Microsoft Excel stops responding. After this problem occurs, Excel stops responding when you try to reopen the... KB#309671. Keywords: Dates, File Name, Files

 
116. How to rename a Chart by Using the Name Box in Excel 2000 This article tells how to rename an embedded chart in Microsoft Excel 2000. In versions of Excel earlier than Microsoft Excel 97, you can rename an embedded chart by clicking the chart one time, clicking the Name box, and then entering the new... KB#212121. Keywords: Charts, SERIES, Format

 
117. Update charts automatically when you enter new data Q. I use an Excel workbook to track and chart daily sales. Since the number of data points changes every day, I have to update the chart manually so it includes the new data. How do I get the chart range to expand automatically? When you select a chart series in Excel 97 or later, the ranges used... Keywords: Charts, SERIES, Sales, Format, Outline, Formulas, Printing, OFFSET, COUNTA

 
118. Generating a List of File Names Many users are surprised to discover that Windows does not provide a direct way to get a list of file names contained in a directory. This tip describes how to create such a list in a text file, which can then be imported into Excel.To generate a list of file names, you'll need to use a DOS command... Keywords: Charts, Dates, Format, Formulas, Printing, File Name, Files, Text Files, Window

 
119. Drag and Drop new data on an existing chart This is an amazing tip. A common problem faced by Excel users is that have a chart of time-series data and need to extend the chart with new figures. Editing all of the data series for a number of charts can be time consuming. Somewhere around Excel 97, the wizards at Microsoft put in a seldom used... Keywords: Charts, SERIES, Months, Borders, VBA, Web

 
120. How to change the Color Palette for Workbooks in Excel This step-by-step article explains how to change the color palette so that you can use custom colors for elements of the workbooks in Microsoft Excel. You can modify colors for many workbook elements, including the following: Worksheet Tabs... KB#288412. Keywords: Charts, Colors

 
121. How to View Sample Chart with the Keyboard When you use the keyboard shortcut, ALT+V, to view a sample chart in step 1 of the Chart Wizard, a sample of the chart does not... KB#157354. Keywords: Charts

 
122. Creating a Custom Chart Type from the Edit menu, or right click on the chart and select Chart Type... from the pop up menu. Click on the Custom Types tab, and choose the User-Defined option below the list of chart types. Click the Add button, then fill in a name and description for your chart. After you press OK, notice that... Keywords: Charts, Fonts, Format

 
123. Charting 101 - Making Your First Chart in Microsoft Excel The first step to making our chart is to select the range of data to be charted. Excel is pretty good about detecting header rows and columns in a selected range, especially if the upper left cell is kept blank. I know it's hard for us compulsive types to leave a header cell blank, where our... Keywords: Charts, Discontiguous

 
124. Jon Peltier\s Chart Tutorials This is a set of tutorials about charting in Microsoft Excel. The first tutorial is the most basic, an introduction to making charts. Follow up tutorials deal with formatting parts of the chart, updating charts with additional or changing data, advanced techniques and tricks, and automating charts... Keywords: Charts, Legend, SERIES, Data Table, Format, Gridlines, Outline, Errors, Formulas, Object, VBA, Web

 
125. Borders of AutoShape on Embedded Excel Chart Change Thickness When Printed When you print an Excel chart that is embedded in another document, AutoShape borders appear thicker than they do if you print the same chart from... KB#307609. Keywords: Charts, Legend, AutoShapes, Dates, Borders, Printing, File Name, Files

 
126. Incorrect Range of Values Displayed on XAxis of XY (Scatter) or Bubble Chart When you create a chart in Microsoft Excel 2000, or open a chart that you created in an earlier version of Excel, and hide a row on the worksheet, the scale of values displayed on the x-axis of the chart changes to an incorrect... KB#237884. Keywords: Charts, Discontiguous

 
127. Creating a thermometer style chart Most people are familiar with "thermometer"-style graphs, which show the percentage of a project completed. It's easy to make such a display in Excel. The key is to create a chart that uses a single cell (containing a percentage value) as a data series. The example below tracks daily progress... Keywords: Charts, Legend, Plot, SERIES, Format, Patterns, Styles, Formulas, Printing

 
128. Locate phantom links in a workbook Q. Whenever I open a particular Excel workbook, I get a message asking if I want to update the links. I've examined every formula in the workbook, and I am absolutely certain that the workbook contains no links to any other file. What can I do to convince Excel that the workbook has no links?... Keywords: Charts, SERIES, Format, Formulas, Links, Printing, Object

 
129. Copying an Embedded Chart to a Chart Sheet 3. To paste the copied chart to the blank chart sheet, select the blank chart sheet tab (this requires two clicks, one to turn off the in-place editing of the chart and another to select the chart sheet), and then click Paste on the Edit menu. You will now have a copy of the embedded chart on its... Keywords: Charts, Formulas, Links

 
130. Embedded Charts in PowerPoint Exhibit Odd Behavior After Being Edited In Microsoft PowerPoint 2000, when you open and close a Microsoft Excel 2000 embedded chart that contains text boxes, you may experience any of the following symptoms: The text boxes may disappear. -or- The text boxes appear truncated. -or- The... KB#290570. Keywords: Charts, Fonts, File Name, Files

 
131. Excel Code Examples I have this massive application that extracts our department telephone list each month and massages it into a number of different formats. There are reports of home phones that go to everyone in the division, reports of addresses that go to key personnel, pivot tables showing building and... Keywords: Charts, Criteria, Borders, Colors, VBA

 
132. How to display More Digits in Trendline Equation Coefficients in Excel When you add a trendline to a chart, and then display the equation and R-squared value for the trendline, the equation shows only the first five digits of each coefficient. For some purposes, this may not be a sufficient number of significant... KB#282135. Keywords: Charts

 
133. Linked Charts Lose Custom Colors When You Update Source Data Linked charts that use custom colors revert to the default colors, when you update the chart data in Microsoft... KB#264517. Keywords: Charts, Colors, Links

 
134. Screen Flickers Constantly After Pasting Excel Chart When you paste a Microsoft Excel chart into a Microsoft Word document, the chart resizes constantly, causing the display to flicker. Both programs may stop responding... KB#150491. Keywords: Charts, Text Box, Format, Links

 
135. Creating Combination Charts A combination chart is a chart that combines two or more chart types in a single chart -- for example, a chart that has a line series and a column series. When you choose the Custom Types tab in the first step of the Chart Wizard, you'll find the following combination charts listed: Many users... Keywords: Charts, SERIES, Format, Formulas, Printing

 
136. Excel Chart Does Not Refresh Properly After Update When you update a link to a Microsoft Excel chart, the chart may not be redrawn... KB#151047. Keywords: Charts, Links

 
137. Drawing Objects on Charts Move After You Save and Reopen When you save a workbook, close it, and then reopen it, drawing objects on charts in the workbook may shift... KB#303809. Keywords: Charts, File Name, Files

 
138. Embedded Excel Chart Resizes in Word When Scrolling to Different Page If you are working in a Microsoft Word 2000 document that contains an embedded Excel chart object, the size of the chart may... KB#257713. Keywords: Charts, Printing, Object

 
139. Transforming Data With Formulas This tip describes a technique that should be in the arsenal of every Excel user. It describes how to use formulas to transform data. The figure below shows a simple example. The text in column A consists of lower case letters. The goal is to transform these cells so they display "proper" case.... Keywords: Charts, Format, Formulas, Printing, PROPER

 
140. Copying Worksheet into Workbook Deletes Defined Name When you copy a worksheet into a workbook, existing defined names may be deleted. Formulas that refer to the deleted defined names return the #NAME?... KB#250825. Keywords: Charts, Errors, Formulas, Defined Name

 
141. Using a Pivot Table as Source for Chart which is also Pivot Table source range. Chart on "Pivot Table and... Keywords: Charts, Download, Format, PivotTables, Links

 
142. Excel Worksheet Changes Font When Copied to PowerPoint Slide When you paste cells or a chart that you copied from Microsoft Excel 2000 into a Microsoft PowerPoint slide, the correct font is not displayed. The Times New Roman font is displayed instead of the font that you selected in Excel. This problem may... KB#248208. Keywords: Charts, Fonts, Object

 
143. Embedded Excel Chart Resizes in Word if Zoom is Set to 20% or Less In Microsoft Word 2000, when you work with an embedded Excel chart object, the size of the chart may... KB#257622. Keywords: Charts, Printing, Object

 
144. How to include Both Value Labels and Percentage Labels on a Pie Chart in Excel 2000 In Microsoft Excel, you can add value labels or percentage labels, but not both, to a pie chart. This article explains how to manually add value labels to a pie chart that uses percentage labels. Add Value Labels to a Pie Chart That Uses... KB#279199. Keywords: Charts, Formulas

 
145. How to Change the Depth of a 3D Surface Chart This article explains how to change the chart depth of a 3-D surface chart in Microsoft Excel 97 for... KB#168253. Keywords: Charts, Legend, SERIES, Format

 
146. How to Rename a Chart Using Name Box In earlier versions of Microsoft Excel, you can rename an embedded chart by clicking the chart once, clicking the Name box, and then entering the new name for the chart. This process changed slightly in Microsoft Excel 97 because clicking a chart... KB#169882. Keywords: Charts, SERIES, Colors

 
147. Graphing If you create a chart in a worksheet, you may find that Excel sets this option by default. You may find that you don't like some of the chart options set by Excel. The great news is that everything in a chart is customizable. All of those settings are just a right-click away.In this case, go to the... Keywords: Charts, Format, VBA, Web

 
148. Excel UserTip: Making an Exact Copy of a Formula Range (Without VBA) Assume that A1:D10 on Sheet1 has a range of cells that contain formulas. Furthermore, assume that you want to make an exact copy of these formulas, beginning in cell A11 on Sheet1. By "exact," we mean a perfect replica -- the original cell references should not change. If the formulas contain only... Keywords: Charts, Format, Formulas, Sounds, Printing, VBA

 
149. Charts Lose Axis Labels, Axis Scaling After You Copy Worksheet When you copy a worksheet, some of the charts on the resulting worksheet may exhibit on or more of the following problems: The axis titles are missing. The scale on the x-axis or y-axis is no longer... KB#248202. Keywords: Charts

 
150. Using Custom Chart Markers in XY Chart When you have an XY chart with many data points, the standard chart markers can become too large to show your data. Here is a simple procedure to replace the standard XY chart markers with a smaller marker. The first method uses a drawing object. As shown in the example below, a small circle... Keywords: Charts, SERIES, Graphic, Download, Object

 

<< (Page 2)  Previous              Next  (Page 4) >>