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.

Updated Aug-2009

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
   

 
2. 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
    
3. 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

 
4. 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

 
5. 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

 
6. 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

 
7. 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
 
 
8. 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

 
9. 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

 
10. 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

 
11. 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

 
12. 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

 
13. 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

 
14. 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
 
 
15. 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
 
 
16. 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

 
17. 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

 
18. 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
 
 
19. 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

 
20. 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

 
21. 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

 
22. 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

 
23. 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

 
24. 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

 
25. 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

 
26. 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

 
27. 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

 
28. 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

 
29. 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

 
30. 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

 
31. 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

 
32. 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

 
33. 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

 
34. 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

 
35. 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

 
36. 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

 
37. 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

 
38. 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

 
39. 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

 
40. 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

 
41. 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

 
42. 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) >>