Home > Excel Help Portal > Excel Charts

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

Excel Charts

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

201. Changing the number of sheets in a new workbook By default, each new Excel workbook begins life with three worksheets. You can, of course, add more sheets to the workbook or delete sheets you don't need. The unused sheets don't occupy additional memory or increase file size, but I generally don't like them in my workbooks. A better approach is... Keywords: Charts, Format, Formulas, Printing

 
202. Changing the Text Size in Excel's Help Excel 2000 and later use HTML Help to display help topics. If you find that the text size is too small (or too large), you can easily change it. If you have a wheel mouse, press Ctl and spin the wheel to change the text size. Make sure that the text window, not the contents window, is active. If... Keywords: Charts, Format, Formulas, Printing, HTML, Internet Explorer

 
203. Forget your password? Q. I saved my workbook with a password, but Excel doesn't recognize it and won't let me open the file. Am I out of luck? First, remember that passwords are case-sensitive. So if you originally entered your password as Xyzzy, typing xyzzy won't work. If you know you're entering the password... Keywords: Charts, Format, Formulas, Password, Printing

 
204. Graphics Exporter Addin This add-in will allow you to export pictures, shapes, charts and more to image files.......Last updated 8th January... Keywords: Add-In, Charts, Export, Links, VBA, Files, Comments

 
205. Spotlight Chart The chart displays a matrix. The marker represents the value at each intersection....At first glance this chart may appear very similar to the Tile chart and to some extent it is. But this chart uses a different approach to the construction of axis labels, markers and the conditional... Keywords: Charts, SERIES, Formulas, Links, VBA

 
206. Delete all input cells, but keep the formulas Your worksheet may be set up with formulas that operate on a number of input cells. Here's an easy way to clear all input values while keeping the formulas intact. Press F5 to display the Go To dialog box, and click the Special button. In the Go To Special dialog, choose the Constants button and... Keywords: Charts, Format, Formulas, Printing

 
207. Pie chart single image When using a picture as the fill effect on a normal pie chart each pie segment contains a copy of the image. One way around this is to use the fill effect for the plot area. This works well for images based on round objects, but it can leave parts of the image sticking out of the... Keywords: Charts, Plot, Links, Object, VBA

 
208. Override Excel's Text Import Wizard If you import text files into Excel, you've undoubtedly encountered the Text Import Wizard, which guides you through parsing the text. If the files you import are always parsed correctly, you may prefer to bypass this wizard and accept the defaults. To do so: Select File, Open Locate the file to be... Keywords: Charts, Format, Formulas, Printing, Files, Text Files

 
209. Avoid error displays in formulas Sometimes a formula may return an error message. Usually, you'll want to know when a formula error occurs. But now and then you may prefer to avoid the messages. You can do so by using an IF() function to check for an error. For example, the formula below displays a blank if the division results in... Keywords: Charts, Format, Errors, Formulas, Printing, Error Message

 
210. Close all workbooks quickly If you find yourself with many workbooks open at the same time, you may be interested in a "hidden" command that will close all workbooks in one fell swoop. The trick is to press Shift while you click the File menu. When you do so, the Close command turns into the Close All command. When you select... Keywords: Charts, Format, Formulas, Printing

 
211. Automatic list numbering It's fairly easy to create a formula that generates consecutively number items in nonconsecutive cells. Refer to the figure below. Column A consists of formulas that refer to column B. The formula in cell A1 is: =IF(B1"",COUNTA($B$1:B1)&".","") This formula, which is copied down to the other cells... Keywords: Charts, Format, Formulas, Printing

 
212. Fix incorrect decimal places during data entry Q. When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. What's wrong? Somehow Excel's fixed-decimal mode was turned on. To return to normal, select Tools, Options to display the Options dialog box. Then click the Edit tab and remove the... Keywords: Charts, Format, Formulas, Printing

 
213. Resize Excel's sheet tabs If your eyesight isn't what it used to be, you may want to increase the size of the sheet tabs displayed in your Excel workbooks. This parameter is determined by a Windows system-wide setting. To change it, select Start, Settings, Control Panel and double-click Display. In the Display Properties... Keywords: Charts, Format, Formulas, Printing

 
214. Rounding to n significant digits Excel includes three functions (ROUND, ROUNDUP, and ROUNDDOWN) that round values to a specified number of digits. In some cases, however, you may need to round a value to a specified number of significant digits. For example, you might want to express the value 1,432,187 in terms of two significant... Keywords: Charts, Format, Formulas, Printing, ROUND

 
215. Picture viewer This workbook contains a very simple database of employees for a fictitious company. Using a few formula and a modified XY scatter chart you can make images appear when there corresponding name is selected from the list. The example contains no macro code. I have previously solved this type of... Keywords: Charts, Download, Formulas, Macro, Setup

 
216. Tile Chart The chart displays a matrix. The colour of the tile represents the value at each intersection....The chart is constructed from a combination of Bar, Column and XY-Scatter. The Bar and Column chart are used to provide category axis labels. The tiles are derived from the XY-scatter chart. The chart... Keywords: Charts, Colors, Formulas, Links, VBA

 
217. Compare ranges by using an array formula In Excel, you can compare the cells in two ranges with an array formula. For instance, to see if all of the values in A1:A100 are identical to those in B1:B100, type this array formula: =SUM(IF(A1:A100=B1:B100,0,1)) Note: This is an array formula and it must be entered using Ctrl-Shift-Enter. The... Keywords: Charts, Format, Arrays, Formulas, Printing

 
218. Stacked side by side column chart The download contains a step by step example of how to create side by side stacked column chart.......I have added an additional example to this chart for use with xl97. The built-in formatting of the category labels is not as smart as it is in xl2000. The xl97 version requires the use of dummy... Keywords: Charts, SERIES, Download, Format, Links, VBA

 
219. Printing Just a Portion of Your Worksheet If you need to print just a small portion of your worksheet: Select the cells that you want to print Choose File - Print In the Print dialog box, choose the Selection option Click OK If you've specified a print area, this will not change it. Note If your selection consists of a non-contiguous range... Keywords: Charts, Format, Formulas, Printing

 
220. Force a global recalculation Q. I find that sometimes my formulas do not get fully calculated. This often happens when I use custom functions created with VBA. Microsoft has acknowledged some problems with the Excel calculation engine in some version of Excel. In order to be assured that all of your formulas have been... Keywords: Charts, Format, Formulas, Printing, VBA

 
221. Pie chart zero removal The workbook contains an example of a pie chart that automatically removes zero values from the pie and the... Keywords: Charts, Legend, Formulas, Links, VBA

 
222. VBA Techniques for Excel Charting Keywords: Charts, SERIES, Fonts, Gridlines, Errors, Formulas, VBA, Links

 
223. Change the color of worksheet tabs Q. Can I change the color of the worksheet tabs in my workbook? Many users find it helpful to color-code the sheet tabs to make it easier to identify specific sheets. If you use Excel 2002, right-click on the sheet tab, choose Tab Color, and then select the color for the tab. If you're using a... Keywords: Charts, Colors, Format, Formulas, Printing

 
224. Display text in multiple lines Q. How can I make text in a cell display in multiple lines? When entering text into the cell, press Alt-Enter to insert a line break. When you do so, Excel will automatically apply text wrapping to the cell. To reformat existing cells so they sport wrapped text, select the cells and then choose... Keywords: Charts, Format, Formulas, Printing

 
225. Gauge chart This gauge chart is constructed on an XY Scatter chart. The dial, numbers and needle positions are calculated using some simple math functions. The dial number labels are linked to text values. The download also includes a variations which will allow for the construction of a dashboard... Keywords: Charts, Download, Links, VBA

 
226. Dividing a graphic The two examples both show the allotted share of resources using a graphic.......The above simply splits the note into sections. Masking parts of the... Keywords: Charts, SERIES, Graphic, Links, VBA

 
227. Pie chart tricks The workbook contains examples of the following pie chart tricks. With a step by step explanations. All the examples are based on a single chart using the secondary axis. So NO overlaying of 2 separate... Keywords: Charts, Format, Formulas, Links, VBA

 
228. Fireworks The download contains vba code to generate a Firework display, well rockets to be precise. The user can control the number of rockets in a display, the number of sparks a rocket contains and the effect of gravity. The animation is displayed through use of an xy scatter chart. I have not posted a... Keywords: Charts, Download, VBA

 
229. Chart Axes and Axis Tricks See also Dummy Series and Combination... Keywords: Charts, SERIES, Gridlines, Links

 
230. Polar plots The add-in helps you to create a polar plot of your angle and distance data....This workbook contains examples on polar plots....v1.1 Removal of unnecessary library... Keywords: Add-In, Charts, Plot, SERIES, Links, VBA

 
231. Conditional line chart This chart displays a line that changes colour depending on whether it is above or below a control line. It is based on a xy-scatter chart, it does require the use of some vba code to update the dummy series used. The download contains a example and brief notes on functions and data... Keywords: Charts, SERIES, Download, Colors, Links, VBA

 
232. 3d xy-scatter chart The chart uses worksheet functions to calculate the rotated positions for the users XYZ values. The download file contains scroll bars which allow you to rotate the chart in the XYZ planes. It also includes a step by step explanation of how to create a chart from the calculated... Keywords: Charts, Download, Links, VBA

 
233. Traffic light chart A very specialized conditional chart which uses a traffic light to illustrate the relationship between 3 value bands and an actual value. The download illustrates how the conditional formulas are constructed and used within the chart. It also contains a step by step guide to creating this... Keywords: Charts, Download, Formulas, Links, VBA

 
234. Calculate the number of days in a month Excel lacks a function for calculating the number of days in a particular month, so you'll need to construct your own formula. If cell A1 contains a date, this formula will return the number of days in the month:... Keywords: Charts, Days, Format, Formulas, Printing

 
235. Chart Formatting Techniques and Tricks Keywords: Charts, Histogram, SERIES, Fonts, Format, Gridlines

 
236. Thermometer chart This thermometer chart is constructed from an XY Scatter and column chart. The column represents the rising mercury. The xy scatter holds the transparent image of a thermometer. The download includes the image and... Keywords: Charts, Download, Links, VBA

 
237. Variable width column chart The column chart has bars of varying width. This is achieved using an Area chart....It is also possible to create stacked and 100% stacked... Keywords: Charts, Links, VBA

 
238. Stacked positive/negative chart This chart uses a combination of built-in stacked bar, a reconfigured side by side bar and some formula. It tackles the problem of maintaining legend order and the bars not obscuring each other. The download contains a step by step... Keywords: Charts, Legend, Download, Formulas, Links, VBA

 
239. Average line charts The download contains a step by step example of how to create an average line in a chart. It also includes a large collection of variations both in the methods and the style of chart that they can be applied... Keywords: Charts, Download, Styles, Links, VBA

 
240. Variable width column chart The column chart has bars of varying width. The effect is achieved using Error bars....With some additional data it is possible to add... Keywords: Charts, Colors, Errors, Links, VBA

 
241. Broken axis on column chart The workbook contains an example of how to create a column chart with a broken value axis. The chart is based on a stacked column chart with additional data series to hold the break and continuation... Keywords: Charts, SERIES, Links, VBA

 
242. Mini xy plots This chart displays a matrix of mini plots. The mini plots values are derived with some vba routines and then displayed on a xy-scatter chart The download contains a example and brief notes on functions and data... Keywords: Charts, Download, Links, VBA

 
243. Scrolling Data Chart The chart uses Named Ranges to define the data to be included in the chart. The scroller allows the user to dynamically change the... Keywords: Charts, Links, VBA

 
244. Header This chart shows the intersection points of 2 lines. The Intersections series is the result of a user defined function. The download illustrates the use of the functions and the layout of the series... Keywords: Charts, SERIES, Download, Links, User Defined Function, VBA

 
245. Plotting Zero and Missing (Empty) Values You can use menu choices Tools, Options and set the Empty cells plotted as values as shown below. When you choose Empty cells plotted as Not Plotted (leave gaps), you chart appears... Keywords: Charts

 
246. Floating bar cluster chart This chart uses a second set of data to mask the bottom of the bar and give a floating effect. The download contains a step by step... Keywords: Charts, Download, Links, VBA

 
247. Staggered axis labels Here are a selection of methods to stagger the x-axis labels and even apply different formatting to specific labels....The workbook contains examples and explanation for chart... Keywords: Charts, Format, Links, VBA

 
248. Clustered column chart with floating gap The workbook contains an example of how to create a clustered column chart with a floating gap. The gap can be either positive or... Keywords: Charts, Links, VBA

 
249. Dynamic and Interactive Charts Keywords: Charts, Months, Links, Combo Box, VBA

 
250. Step Line charts Here are a selection of alternative chart types and methods for plotting step line charts....The workbook contains step by step explanation for chart... Keywords: Charts, Links, VBA

 

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