Home > Excel Help Portal > Excel Charts

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

Excel Charts

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

1. How to Create PivotTables from Multiple Consolidation Ranges In Microsoft Excel, you can create a PivotTable from multiple consolidation ranges. These ranges can be on the same worksheet, on separate worksheets, or even in separate workbooks. This article provides two examples of PivotTables created... KB#142589. Keywords: Charts, Plot, PivotTables


 
3. How to Dynamically Create Excel 5.0 Charts in OLE 2.0 Control This article demonstrates how to create new Excel 5.0 charts at run-time to be displayed in the Visual Basic OLE 2.0 container... KB#147803. Keywords: Charts, Legend, SERIES, OLE, AutoFormat, Arrays, Class, VBA, Object

 
5. How to create PivotTables from Multiple Consolidation Ranges in Excel 2000 In Excel 2000, you can create a PivotTable from multiple consolidation ranges. These ranges can be on the same worksheet, on separate worksheets, or even in separate workbooks. This article provides two sample PivotTables that are created... KB#213947. Keywords: Charts, Plot, PivotChart, PivotTables

 
7. Quick Chart VBA Examples When you record a macro to add a chart object to a worksheet, Excel comes up with the following... Keywords: Charts, SERIES, Outline, Arrays, Errors, Defined Name, VBA, Macro, Object, Error Message, Window, EVEN

 
9. How to Create a Gantt Chart Using Hours as the Scale You can use a Gantt Chart to show the progress of a project or the relationship among the tasks in a project in relation to time. The unit of time that is most frequently used is the day unit. However, you can also use the hour as the unit of time... KB#152820. Keywords: Charts, GANTT, Legend, SERIES, Days, Borders, Format, Patterns, Formulas, Toolbar

 
11. How to Change Chart Type of a Series in Combination Chart If you create a combination chart of the Column-Area, Line-Column, or Line-Column on 2-Axes chart types, you may want to change the number of series plotted on each chart type. The Chart Wizard automatically takes half of the series (or one more... KB#192641. Keywords: Charts, SERIES, Format, Errors

 
13. How to use the Chart Wizard in Excel 2000 This step-by-step article explains how to use the Chart Wizard in Microsoft Excel 2000 to create a chart. Create a Chart To create a chart, you must first enter the data for the chart on an Excel worksheet. Select that data, and then use the... KB#304421. Keywords: Bar Chart, Charts, Legend, SERIES, Data Table, Format, Gridlines, Object

 
15. Contextures Sample Spreadsheets Assign Employees to Single Task Per Day-- Names are removed from the data validation dropdown list once they've been assigned to a daily task. DataValDailyList.xls 31 kb Create Dependent List for Selected Column -- The first dropdown list is based on column headings. The second list contains unique... Keywords: Charts, Plot, Advanced Filter, AutoFilter, Sorting, Dates, Days, Sales, Formulas, PivotTables, Printing, Combo Box, Macro, UserForm, Scenarios, Validation, RAND

 
17. How to consolidate Multiple Worksheets to a Single Sheet in Excel 2000 This step-by-step article describes how to consolidate multiple worksheets to a single sheet in Excel 2000. You can summarize data from one or more source areas by consolidating it and creating a consolidation table. These source areas can be on... KB#214270. Keywords: SERIES, Consolidate, Links, PivotTables, Templates

 
19. Creating charts with time as X-axis Roy asks this week's question. I have a small problem regarding the x-axis on charts. The data that I have needs to be plotted against time down to the minute. The data points are randomly spaced, so there is not an equivalent amount of time between each data point. When Excel creates my chart, it... Keywords: Charts, SERIES, Time Series, Dates, Days, Sales, Format, VBA, Web

 
21. Error Free VBA Now that you've had a good laugh at the title of this page ("Error Free VBA"), I'll point out that although you cannot make your VBA code error-free, you can at least try to make it error-resistant. In my Quick Chart VBA page and other pages on this site, I've presented some VBA procedures to help... Keywords: Charts, SERIES, Format, Outline, Errors, VBA, Macro, Object, UserForm

 
23. The Chart Wizard button on the Insert menu (shown below). The data can be selected prior to running the chart wizard, filled in while running the chart wizard, or added to the chart later. The Chart Wizard runs through a series of steps that help you set up your chart. The Standard Types tab of Step 1 of the Chart... Keywords: Charts, Plot, SERIES, Colors, Fonts, Patterns, Styles, Object, Web

 
25. How to Use the ApplyCustomType Method to Format Charts When you run a Microsoft Visual Basic for Applications macro in Microsoft Excel 2000, you can use the ApplyCustomType method to apply standard or custom chart types to a chart or a series in a chart. This article explains how to use... KB#213521. Keywords: Charts, SERIES, Format, Errors, VBA, Macro, Object, Error Message, Web

 
27. Adding Series to XY (Scatter) Chart with Second X Axis When you add a second series to an xy (scatter) chart, the new values will be added with respect to the same x-axis values as the first series. This article illustrates how to add a second series to an xy scatter chart that utilizes a second set of... KB#115073. Keywords: Charts, Legend, SERIES, Format, Toolbar, Discontiguous

 
29. How to create a Gantt chart using hours as the scale You can use a Gantt chart to show the progress of a project or the relationship among the tasks in a project in relation to time. The unit of time that is most frequently used is the day unit. However, you can also use the hour as the unit of time... KB#213915. Keywords: Charts, GANTT, SERIES, Format, Patterns, Formulas

 
31. How to Create a Biorhythm Chart It is possible to use Microsoft Excel to create a biorhythm chart. A biorhythm chart tracks the physical, emotional, and intellectual cycles of a person over a 29-day period. These three cycles are further broken down to the following day... KB#151439. Keywords: Charts, Legend, SERIES, Dates, Days, Format, Patterns, Styles, Formulas, TODAY, SIN

 
33. How to change the Chart Type of a Series in a Combination Chart in Excel 2000 In Microsoft Excel 2000, if you create a combination chart of the Column-Area, Line-Column, or Line-Column on 2-Axes chart types, you may want to change the number of series that are plotted on each chart type. The Chart Wizard automatically... KB#213881. Keywords: Charts, SERIES, Format, Errors, Error Message

 
35. How to Export Data to Microsoft Excel This article describes how to export data from MSN Money Investing into Microsoft Excel. This process can also be used to import the data into other programs that recognize text files and Hypertext Markup Language (HTML). This article includes... KB#179510. Keywords: Charts, Export, Format, Symbol, File Name, Files, Text Files, HTML

 
37. How to Create a Spiral Chart It is possible to create a chart in Microsoft Excel that resembles a spiral or spirograph. The spiral chart is an XY Scatter chart that plots the series of values 1 through 128 against the cosines of those... KB#151445. Keywords: Charts, Legend, SERIES, Format, Patterns, Formulas, ROW, SIN, COS

 
39. How to Consolidate Multiple Worksheets to a Single Sheet You can summarize data from one or more source areas by consolidating it and creating a consolidation table. These source areas can be on the same worksheet as the consolidation table, on different sheets in the same workbook, or in... KB#141577. Keywords: SERIES, Consolidate, Links, PivotTables, Templates

 
41. How to Use the ApplyCustomType Method to Format Charts When you run a Microsoft Visual Basic for Applications macro in Microsoft Excel 97, you can use the ApplyCustomType method to apply standard or custom chart types to a chart or a series in a chart. This article explains how to use the... KB#167279. Keywords: Charts, SERIES, Format, Errors, Macro, Object, VBA, Error Message, Toolbar, Web

 
43. How to Use the Internet Assistant Wizard The Internet Assistant Wizard is not new to Microsoft Excel, but it has changed significantly since it was released as a free add-in available on the Microsoft World Wide Web site in January 1996. The Internet Assistant Wizard is now an... KB#158079. Keywords: Add-In, Charts, SERIES, Export, Format, Setup, Setup Program, HTML, Internet Explorer, Web

 
45. How to Create a Bell Curve Chart A bell curve is a plot of normal distribution of a given data set. This article describes how you can create a chart of a bell curve in Microsoft... KB#213930. Keywords: Analysis ToolPak, Charts, Histogram, Legend, Plot, SERIES, Format, Formulas, AVERAGE

 
47. How to use the Undo Feature with Inserted Objects in Office XP Programs When you insert an object from one program (for example, a Microsoft Excel worksheet object) into another program (for example, Microsoft Word), and then you deactivate and reactivate the inserted object, the Undo command may behave differently... KB#290148. Keywords: Charts, Microsoft Access, Object, Toolbar

 
49. How to Trap Events for an Embedded Chart In Microsoft Excel 97, you can associate a chart sheet in a workbook with a Visual Basic module. This means you can create a macro that runs when certain events occur on the chart sheet. However, this functionality does not apply to charts that... KB#161858. Keywords: Charts, Borders, Class, VBA, Macro, Object, Web, Window

 
51. How to plot Values Against a Recommended Range in Excel 2000 This step-by-step article shows you how to create a chart that is a combination of the line and area chart types, this chart plots your data against a recommended range. In Microsoft Excel it is possible to display collected data against a desired... KB#211938. Keywords: Charts, Legend, Plot, SERIES, Colors, Format, Gridlines, Toolbar

 
53. How to Trap Events for an Embedded Chart In Microsoft Excel, you can associate a chart sheet in a workbook with a Visual Basic module. This means that you can create a macro that runs when certain events occur on the chart sheet. However, this functionality does not apply to charts that... KB#213738. Keywords: Charts, Borders, Class, VBA, Macro, Object, Web, Window

 
55. How to create Two Pie Charts in One in Excel 2000 This step-by-step article shows you how to create two pie charts on one chart sheet in Excel 2000. Pie charts show the relationship or proportions of the parts to the whole. This chart type is useful for emphasizing a significant element. Normally,... KB#213928. Keywords: Charts, Legend, SERIES, OLE, Format

 
57. How to use the Send To Command to Send Worksheet Selections as EMail in Excel This article describes how to use the Send To command to send worksheet selections as e-mail. back to the top Improvements and Requirements With Excel 2003, you can now send a message as a fax by using an Internet fax service. To turn on the Send... KB#826920. Keywords: Charts, Format, PivotTables, HTML

 
59. How to Change the Taper Style for All Series in a Chart Microsoft Excel 97 includes many new built-in chart types, including cone and pyramid charts. By default, these chart types contain cones or pyramids that taper to a point for each data point in a series; the height of each cone or pyramid is equal... KB#162092. Keywords: Charts, SERIES, Styles, VBA, Macro, Object, Toolbar, Web

 
61. How to Plot Values Against a Recommended Range In Microsoft Excel, it is possible to display collected data against a desired or recommended range for the data. This range is usually displayed as a shaded or patterned bar on the plot area against which the data is plotted. This article contains... KB#161670. Keywords: Charts, Legend, Plot, SERIES, Colors, Format, Gridlines, Toolbar

 
63. How to Copy Text to TextBoxes Using the Characters Method In a Microsoft Excel worksheet, you can use TextBox objects to add text that is not limited by the boundary of a cell. You can also use text boxes on dialog sheets and chart sheets when specially formatted text is required. The text string that... KB#148815. Keywords: Charts, Text Box, VBA, Object, Web

 
65. Excel 2002 Series.ApplyDataLabels Method Generates Error on MFC Clients When you use DISPID binding that is based on an earlier version of the Excel type library to automate Excel 2002, you may receive the following error message when the program calls the ApplyDataLabels method of a Chart Series object:... KB#306659. Keywords: Charts, SERIES, Errors, Class, Object, Error Message, File Name, Files

 
67. How to Create a Column Chart with Two Y Axes In general, a combination or overlay chart must have a second y-axis. However, Microsoft Excel places the column series plotted on the secondary axis in front of the column series plotted against the primary axis. In many cases, the overlay... KB#121819. Keywords: Charts, Plot, SERIES, Sales, Format, Window

 
69. How to Copy Text to Text Boxes Using the Characters Method In a Microsoft Excel worksheet, you can use text box objects to add text that is not limited by the boundary of a cell. You can also use text boxes on dialog sheets and chart sheets when specially formatted text is required. The text string that... KB#213802. Keywords: Charts, Text Box, VBA, Object, Web

 
71. Utility to color pie slices in a pivot chart consistently Shari sends in this week's question. I haven't been able to find the answer to this one from our IT department, Excel help files, or Microsoft online help, and am hoping you can... Keywords: Charts, Sorting, Years, Colors, PivotTables, Class, VBA, Macro, Web, Scenarios

 
73. Using Visual Basic to Create a Chart Using a Dynamic Range When you record a macro to create a chart, the source address of cells used to create the chart is fixed by Microsoft Excel. This article contains a sample Microsoft Visual Basic for Applications macro that you can use to create a chart when... KB#146055. Keywords: Charts, VBA, Macro, Toolbar, Web

 
75. Macro to Extract Data from a Chart In Microsoft Excel, you can retrieve data from a chart even when the data is in an external worksheet or workbook. This is useful in situations where the chart was created from, or linked to, another file that is unavailable or has been damaged... KB#137016. Keywords: Charts, SERIES, Errors, VBA, Macro, Object, Web

 
77. How to Create a Chart with Discontiguous Ranges When you record a macro to create a chart using discontiguous ranges, the source address of cells used to create the chart is fixed by Microsoft Excel. This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure)... KB#146058. Keywords: Charts, VBA, Macro, Toolbar, Web, Discontiguous

 
79. How to Add Totals to a Stacked Column Chart This article contains information about adding total values to a stacked column chart in Microsoft... KB#151521. Keywords: Charts, Legend, Plot, SERIES, Borders, Format, Patterns, RIGHT

 
81. Chart Types in Microsoft Excel Excel allows you to create charts in a variety of types: Bar Charts, Column Charts, Line Charts, Area Charts, Scatter Charts, Pie Charts, Stock Charts. You can define a chart type when creating your chart in Step 1 of the Chart Wizard, or on an existing chart using the technique descibed below. You... Keywords: Charts, Plot, SERIES, OLE, Colors, Patterns, Menu Command, Web

 
83. Chart and Graph Tutorial 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. Animated Line Chart You can use the Wait method in... Keywords: Bar Chart, Charts, GANTT, Plot, SERIES, Time Series, Trend line, Forecasting, Sales, Format, Formulas, PivotTables, Object, VBA, Links

 
85. Help making better Excel graphs If you type titles directly into the Chart Options they will be static and unchanging, regardless of what happens to your data. You may wish to make a title update itself to include a variable element such as the current month name. Edit your chart and click on the existing chart title - then in... Keywords: Charts, Legend, SERIES, Data Table, Rank, Format, Patterns, Formulas, Printing, Links

 
87. Excel Chart Pastes as Object in NonEnglish Version When you use the Paste command to put a Microsoft Excel chart into a Word document, the chart may enter Word as an Excel object. This symptom occurs in a non-English version of Word 2002. Note In the English version of Word 2002, the Excel enters... KB#328528. Keywords: Charts, Dates, Format, Object, File Name, Files, Web

 
89. Labels in Pasted Excel Chart Object Are Distorted, Unreadable, or Incomplete When you paste an Excel 2002 chart into a document, the chart X-axis labels may be distorted, unreadable, or... KB#815196. Keywords: Charts, Dates, Fonts, Object, File Name, Files, Web

 
91. How to Programmatically Create a Chart Without Selecting a Range of Cells When you record a macro to create a chart (on the Tools menu, point to Macro , and then click Record New Macro ), the range of cells used to create the chart is fixed by Microsoft Excel. This article contains a sample Microsoft Visual Basic... KB#213352. Keywords: Charts, VBA, Macro, Web

 
93. Visual Basic Module to Create Gantt Chart In Microsoft Excel, you can create Gantt Charts that show task status for project planning and control. The example in this article shows the steps necessary to generate this type of charts using a Visual Basic, Applications Edition,... KB#123260. Keywords: Charts, GANTT, Legend, Plot, SERIES, Days, Borders, Format, VBA, Macro, Web, DATE

 
95. Visual Basic Module to Create a Gantt Chart In Microsoft Excel, you can create Gantt charts that show the task status for project planning and control. This article describes how to programmatically generate this type of chart using a Microsoft Visual Basic for Applications... KB#213447. Keywords: Charts, GANTT, Legend, SERIES, Days, Format, VBA, Macro, Web, DATE

 
97. Charting Data From Different Sheets A more detailed description of a chart and its series formula is presented in the The Chart Series Formula page elsewhere on this site, but a brief description here is in order. Every chart series has a formula which describes the data in the series. For example, a simple series formula looks like... Keywords: Charts, Plot, SERIES, Statistics, Format, Arrays, Formulas, Links, INDIRECT

 
99. How to Change the Taper Style for All Series in a Chart Microsoft Excel 2000 includes many built-in chart types, including cone and pyramid charts. By default, these chart types contain cones or pyramids that taper to a point for each data point in a series; the height of each cone or pyramid is equal... KB#213729. Keywords: Charts, SERIES, Styles, VBA, Macro, Object, Web

 

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