Home > Excel Help Portal > Excel Charts

<<  (Page 1)  Previous              Next  (Page 3)  >>

Excel Charts

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

51. How to Create a UserDefined Chart Format In Microsoft Excel, you can produce charts with a consistent look by creating a user-defined chart format. This article contains steps you can follow to create a sample chart, to use that sample chart as the basis for a user-defined chart format,... KB#142124. Keywords: Charts, AutoFormat

 
52. Combining Different Chart Types into a Single Chart See also Chart Axes and Axis Tricks and Dummy Series. -- Introduction to Combination Charts Excel offers a wide range of chart types: Line Charts, Column Charts, Area Charts, Bar Charts, Scatter Charts, and Pie Charts, to name but a few. You can even mix different types on a single chart by... Keywords: Add-In, Charts, Legend, SERIES, Whisker, Download, OLE, Colors, Format, Patterns, Errors, Links, Menu Command

 
53. How to Create a Chart with NonContiguous Ranges When you record a macro to create a chart using non-contiguous 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 that you can use... KB#213351. Keywords: Charts, Macro, VBA, Web

 
54. Timeline Chart in Excel MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Bar Chart, Charts, Legend, Plot, SERIES, Data Table, Years, Borders, Colors, Format, Patterns, VBA, Web

 
55. Help using the Excel SUMPRODUCT() function ). It can contain up to 30 different arrays. The following example shows a simple model to calculate the cost of four different clinical procedures. Six... Keywords: SERIES, Criteria, Days, Format, Arrays, Formulas, COUNT

 
56. Visual Basic Examples Using DDE Dynamic Data Exchange (DDE) is a method to exchange data with another DDE-compliant program. In Microsoft Excel, one way you can use DDE is through a Visual Basic for Applications... KB#213626. Keywords: SERIES, DDE, Format, Arrays, VBA, Macro, Object, Web

 
57. Visual Basic Macro to Show Active Cell's Range Names This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that finds all named ranges that contain the active cell on a worksheet and displays the names in a series of message... KB#213413. Keywords: SERIES, Errors, Defined Name, VBA, Macro, Object, Web

 
58. Help using Excel spreadsheet functions - If, Rank and Errors The IF function allows you to select one of two alternative values which are dependent upon a specified condition. It is in the format: =IF(Condition, Value if True, Value if False). If the condition is true then the first value is returned, otherwise the second is used. IF() initially gives you... Keywords: SERIES, Rank, Errors, Formulas

 
59. Preventing the Office Clipboard Toolbar from Appearing It is possible to prevent the Clipboard toolbar from automatically appearing when you use multiple Copy commands in any Microsoft Office program. This article explains how to do this by modifying the Windows Registry. NOTE : You cannot disable... KB#207438. Keywords: Charts, Clipboard, Registry, Toolbar

 
60. Linking Charts Does Not Work Correctly If Name Has More Than 64 Characters In Microsoft PowerPoint 2000 or Microsoft Word 2000, when you link to a chart object created in Microsoft Excel 2000, you may experience the following problems. Microsoft Word 2000 When you paste the chart as a link in a Word 2000 document,... KB#249060. Keywords: Charts, Errors, Links, Object, Error Message, File Name, Files

 
61. How to Turn off Shortcut Menus Delete Rename Move or Copy...... KB#213757. Keywords: Charts, Plot, SERIES, AutoShapes, Query, ActiveX, OLE, Formulas, PivotTables, VBA, Macro, Object, Web

 
62. How to create a Column Chart with Two YAxes in Excel 2000 This step-by-step article shows you how to create a chart with two y-axes, so that both axes can be clearly seen. In general, a combination or overlay chart must have a second y-axis. However, Microsoft Excel 2000 places the column series that... KB#214011. Keywords: Charts, Plot, SERIES, Sales, Format, Toolbar

 
63. How to Insert a Graphic File in Microsoft Excel Worksheet In Microsoft Excel it is possible to insert graphics files. The type of file you can insert depends on the graphic import filters that are installed on your computer. Typically, filters are installed when you install software programs that... KB#142133. Keywords: Plot, Graphic, Format, Printing, Setup, Files

 
64. Labels on XAxis of XY (Scatter) Chart Distorted When Rotated 90 Degrees In an xy (scatter) chart that uses x-axis labels, the x-axis labels may be distorted, truncated, or... KB#236298. Keywords: Charts, Plot, Text Box, Fonts, Format, Formulas, Object

 
65. Visual Basic Macro to Break Chart Links Charts in Microsoft Excel are, by default, linked to the range of cells on the worksheets that they were created from. You can break the links by converting the cell references to values in the SERIES formula for the chart. This article describes... KB#213443. Keywords: Charts, SERIES, Formulas, Links, VBA, Macro, Toolbar, Web

 
66. How to use Lotus 123 Commands to Attach Text Data Labels to a Chart in Excel 2000 This step-by-step article shows you how to use Lotus 1-2-3 commands to attach text data labels to a chart in Excel 2000. To create text data labels in Microsoft Excel 2000, you must attach them to data points by using the Attach Text command on... KB#214040. Keywords: Charts, SERIES, Styles, Macro, Object

 
67. How to use the "Send To" Menu Command to Send Worksheets and Workbooks as EMail in Excel The Send To menu command has been improved in Microsoft Excel 2002. This article discusses how to use this command to send worksheet selections as e-mail.Improvements and Requirements With Excel 2002, you can now send a selection from a worksheet,... KB#289272. Keywords: Charts, Format, PivotTables, Menu Command, HTML

 
68. How to Create a GIF File from a Microsoft Excel Chart To programmatically create a graphics file from a Microsoft Excel chart, use the Export method. This article contains a sample Microsoft Visual Basic for Applications macro that creates a .gif file from a chart in a Microsoft Excel workbook. NOTE:... KB#163103. Keywords: Charts, Graphic, Export, VBA, Macro, Files, Toolbar, HTML, Web

 
69. How to Disable Shortcut Menus Delete Rename Move or Copy... Select All Sheets View Code... KB#161440. Keywords: Charts, Plot, SERIES, AutoShapes, Query, ActiveX, OLE, Formulas, PivotTables, VBA, Macro, Object, Web

 
70. Benefits of On Line Consulting Read Microsoft Solution Study about development work performed by John F. Lacher CPA for D-Tools. The D-Tools development included components built with Visual Basic 6, Active Server Pages, Jet Databases, Visio, Excel, Access, Word and Project. Custom Application Development Via the Internet -... Keywords: Charts, Years, OLE, Formulas, PivotTables, Printing, Macro, VBA, Files, Text Files

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

 
72. Excel dynamic graphs using Names, Series and Offset Line graphs (charts) are an appropriate format for showing values over a period of time. Unfortunately, if there is one data series which has fewer categories than another and contains values of zero, a line plotted by Excel will correspondingly fall to zero on the Y axis. This looks misleading on... Keywords: Charts, SERIES, Data Table, Months, Format, Formulas, Defined Name, OFFSET

 
73. How to Turn Off Automatic Font Scaling in All Charts In Microsoft Excel 97, there is a limit of 256 fonts that can be used by the program. Charts that use the automatic scale feature have two fonts instead of one. This article explains how to programmatically turn the automatic scale feature off in... KB#292263. Keywords: Charts, Fonts, Errors, VBA, Macro, Error Message, Web

 
74. How to Use Visual Basic to Create a Dynamic Chart When you record a macro to create a chart, the source address of the cells that you use to create the chart are fixed by Microsoft Excel. This article contains a Visual Basic for Applications macro that you can use to create a chart when the... KB#213780. Keywords: Charts, VBA, Macro, Object, Web

 
75. How to Automatically Set Min and Max Scale for YAxis In Microsoft Excel, you can set the Minimum and Maximum properties of the y-axis scale to any value. The example in this article shows the steps necessary to create a Microsoft Visual Basic for Applications procedure that determines the minimum... KB#213644. Keywords: Charts, SERIES, Arrays, VBA, Macro, Web

 
76. How to Control the Placement of Objects In Microsoft Excel 97, you can control how charts, drawing objects, AutoShapes, controls, and other objects contained in a worksheet are attached to the cells below them. This article explains how to set the Placement property for objects in... KB#168651. Keywords: Charts, AutoShapes, Format, Styles, Errors, Class, Macro, Object, VBA, Window

 
77. How to Create a Pie Of Pie Chart or a Bar Of Pie Chart This article describes how to create a Pie Of Pie chart or Bar Of Pie chart in Microsoft Excel... KB#192063. Keywords: Charts, Plot, SERIES, Format

 
78. How to Add New Data to a Data Map Chart In Microsoft Excel, you can add additional columns of data or new rows of data to an existing data map. However, when you insert the new data, you need to include the matching column of geographic... KB#147737. Keywords: Charts, Discontiguous

 
79. How to Automate Inserting an Excel Chart into Word This article includes a sample Microsoft Visual Basic for Applications macro that inserts an existing Microsoft Excel chart into a new Word... KB#212514. Keywords: Charts, VBA, Macro, Object, File Name, Web

 
80. How to Control the Placement of Objects In Microsoft Excel 2000, you can control how charts, drawing objects, AutoShapes, controls, and other objects contained in a worksheet are attached to the cells below them. This article explains how to set the Placement property for objects in... KB#211835. Keywords: Charts, AutoShapes, Format, Styles, Errors, Class, Macro, Object, VBA, Window

 
81. How to create a Normal Chart from a PivotTable in Excel 2000 This step-by-step article describes how to create a normal chart (not a PivotChart) from PivotTable data. Ordinarily, if you use a PivotTable as the source data for your chart, Microsoft Excel always creates a PivotChart. To create a normal chart... KB#231421. Keywords: Charts, PivotChart, PivotTables, Object

 
82. How to add Text to the XAxis or YAxis on a Chart in Excel 2000 This step-by-step article describes how to add text to a specific point on a chart in Microsoft Excel 2000. Normally, when you try to add text to the x-axis or y-axis of a chart, you cannot manually edit the numbers on the axis to change them to... KB#213958. Keywords: Charts, Colors, Custom Number Formats, Gridlines, Patterns

 
83. How to Sort Sheets in a Workbook Although there is no built-in tool to alphanumerically sort sheets, charts, Microsoft Excel 4.0 macro sheets, and dialog sheets in a workbook, you can do this with a macro. Note In Excel 97, Excel 2000 and Excel 2002, you cannot sort modules... KB#812386. Keywords: Sorting, Macro, VBA, Web

 
84. Protecting Charts in Microsoft Excel The VBA equivalent of this manual sheet protection is: ActiveChart.Protect Password:="drowssap", DrawingObjects:=True, Contents:=True Note: despite being protected, the chart sheet may still be deleted. An embedded chart can be protected manually by selecting Protection from the Tools menu, then... Keywords: Charts, SERIES, Text Box, Format, Formulas, Links, Object, VBA

 
85. Alternatives to Nested IF Functions Excel's IF function provides some simple decision-making capability to a worksheet. The IF function accepts three arguments: The formula below, for example, returns 1 if cell A1 contains "A". If cell A1 does not contain "A", the formula returns an empty string. =IF(A1="A",1,"") For more... Keywords: Charts, Format, Formulas, Printing, VBA, Web, VLOOKUP, CONCATENATE

 
86. Add a Trendline to an Excel Chart to Forecast Results Many know how to use Excel to chart existing data. It is also possible to have Excel automatically add a trend line to show the slope of data points. In this chart, I've been using Ron Martin's Weight Loss Tracker for 3 weeks. The green line is actual data and the straight black line is where I... Keywords: Charts, SERIES, Trend line, Days, Colors, Format, Styles, VBA, Web

 
87. Resizing and Moving Charts in VBA You can always record a macro to find out how to do something. Select a chart, then record a macro while you move it and resize it. The result is something like... Keywords: Charts, VBA, Macro, Object

 
88. Jon Peltier's Web Site -- Chart Index Chart Pages Visit Jon's Home Page -- http://peltiertech.com/index.html Align (Overlay) Charts Arbitrary Axis Scale Arbitrary Gridlines Arbitrary Gridlines, Take Two Gridlines, Arbitrary, Take Two Label Last Point Probability Chart Reciprocal Axis Chart Stacked Line Chart Tertiary Y Axis Conditional... Keywords: Charts, GANTT, SERIES, Whisker, Months, Years, Statistics, Fonts, Format, Gridlines, Errors, Formulas, Links, Combo Box, VBA, Web

 
89. Not Enough Memory message Are you creating each chart as its own chart sheet? Excel can handle 16 million cells on a worksheet, but the quiet secret is that is can not handle a lot of worksheets. The help file says that the number of worksheets is limited by "available memory". I regularly experience the problem that you... Keywords: Charts, Errors, Macro, UserForm, VBA, Error Message, Web

 
90. How to Add Text to the X or Y Axis on a Chart In Microsoft Excel, when you try to add text to the x-axis or y-axis of a chart, you are unable to manually edit the numbers on the axis to change them to... KB#137528. Keywords: Charts, Custom Number Formats, Gridlines

 
91. How to Programmatically Print All Embedded Charts on a Worksheet In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro that prints all embedded charts in an Excel worksheet. Each chart is printed on a separate... KB#213460. Keywords: Charts, Printing, VBA, Macro, Object, Web

 
92. Excel Frequency function Frequency is an unusual array function and it works differently to most other normal functions. It can not simply be typed into a cell or even entered properly using the Excel Function Wizard. Note that this function does not analyse values into categories e.g. household expenditure into groups... Keywords: SERIES, Arrays, Formulas

 
93. How to Display the Current Date and Time with Text You can enter the current date and time as text by using the TEXT function with the TODAY or NOW functions. For example, to display Today is 2/18/98 where 2/18/98 is the current date, use the following formula: Today is TEXT(TODAY(),m/d/yy")... KB#214093. Keywords: Charts, Format, Formulas, TEXT, TODAY, NOW

 
94. How to Create a Single Stacked Column or Bar Chart In Microsoft Excel, you can create a single stacked column or bar... KB#151353. Keywords: Bar Chart, Charts, Legend, SERIES, Format

 
95. Introduction to Charting in Microsoft Excel 3D Exploded Pie Chart"The Trailer Trash of Charting" Is That a Chart, or Is Your Dog Ill?Some don't think Excel's palette has enough colors! Fax-Friendly Chart Simple Primary Colors Are Best Doesn't the column provide for easier... Keywords: Bar Chart, Charts, SERIES, Colors, Styles, Printing

 
96. How to Create a UserDefined Chart Format In Microsoft Excel, you can produce charts with a consistent look by creating a user-defined chart format. This article describes how to create a sample chart, how to use that sample chart as the basis for a user-defined chart format, and how to... KB#214265. Keywords: Charts, SERIES, Format

 
97. Error Trying to Quick View Microsoft Excel Workbook When you use the Quick View command in Microsoft Windows 95 to view a Microsoft Excel workbook file, you may receive the following error message There is no viewer capable of viewing Microsoft Excel Worksheet files. and you are unable to view... KB#150366. Keywords: Charts, Errors, Error Message, Files

 
98. Chart Source Data Of course, charting is all about displaying data. Excel provides a multitude of ways to get the data you want to plot into a chart. You can select it prior to starting the Chart Wizard, or in Step 2 of the Wizard. Or you can get to the source data through the Source Data menu command. You can open... Keywords: Charts, Plot, SERIES, Borders, Styles, Menu Command, Discontiguous

 
99. How to Create Excel Chart w/OLE Automation from Visual Basic This article illustrates how you can use Automation in a Visual Basic program to create an Excel workbook that contains a chart embedded on a... KB#142387. Keywords: Charts, SERIES, Command Button, VBA, Object

 
100. Books about Excel I have included a selection of books which have mostly been awarded five stars by readers who have purchased them. If you follow these links to Amazon, they are sold with a discount of 15%-30% A great reference for the beginner and the pressed-for-time, this book is organized as a series of... Keywords: Charts, SERIES, Dates, Format, Formulas, Links, VBA, CD-ROM

 

<< (Page 1)  Previous              Next  (Page 3) >>