Hp Elitebook 840 G5 Gaming, Arcadia, Fl Zip Code, Contech Ct-600 Price, City College Courses Offered, Moorhen And Coot Difference, Whirlpool Wrf767sdhz Reviews, Aqa A Level Chemistry Past Papers, Baby Pheasant Food, Windows 10 Ultimate Performance Mode Gaming, " />

Notre sélection d'articles

excel 2010 charts tutorial pdf

Posté par le 1 décembre 2020

Catégorie : Graphisme

Pas de commentaire pour l'instant - Ajoutez le votre !

This opens the Size and Properties window and shows the Size tab. You can change which line is stacked at the top by changing the order of the series. Now, whenever you click to select an image in the list, it appears. Excel creates a new table that has the same structure but combines the data from the other tables. The classic line chart, which draws a line connecting all the points in the series. To change how Excel scales the category axis, select the chart, and then choose Chart Tools | Layout?Axes?Axes?Primary Horizontal Axis?More Primary Horizontal Axis Options to show the Format Axis dialog box. However, this action resets all the changes you've made. Note: This list includes only the templates on your computer. D: Incorrect. 2. However, changing a part of a table isn't exactly like changing a bunch of cells. Tabs at the bottom of the screen identify the different worksheets available to you - Ill show you a little later how to give them meaningful names. In this example, you can't distinguish all of the error bars, because sometimes the points and error bars overlap (consider the two data points around age 40). For example, ProductList makes a good name. Don't click anywhere else yet. You can also choose Chart Tools | Design?Type?Change Chart Type to make a choice from the Change Chart Type dialog box, which looks just like the Insert Chart dialog box shown in Figure 4-3. After all, even if you don't hit a connection point, it still looks like your line is connected to the shape. 8. A: Incorrect. To see how grouping can simplify complex worksheets, check out the sales report data shown in Figure 2-1. To remove a selected element from your chart, just press Delete. No matter what you do, the center of the donut is never filled in (unless you decide to add some text there using Excel's drawing tools, which are covered in Chapter 6). As you move over a table style, Excel uses its live preview feature to change the table, giving you a sneak peak at how your table would look with that style. 3. Figure 4-17.Though a cone chart looks a little different, it's really just a column chart in disguise. Chart styles make it easy for you to change the colors and visual styling in a chart. Leave it to Microsoft to also include not-so-basic shapes like rings, lightning bolts, suns, moons, and even a happy face. As you can see, the area chart makes a more dramatic point about the rising sales in Region 2. Here's what you need to do: 1. Different shapes support different types of alterations. Two simple and useful choices are "Fixed value" (which lets you specify the same measurement of uncertainty for every value), and Percentage (which lets you specify a percentage uncertainty). You can nearly as easily change a picture's size. The Consolidate dialog box appears, as shown in Figure 2-10. (The table name is important only if you choose to use it in a formula, as described on page 1-29.). Simply prefix these values with an apostrophe ('). However, you can easily switch your chart over to a new worksheet if you're running out of room—just follow these steps: 1. You press Enter to create more lines, each of which is called a point. This data is perfect for a column chart, but different subtypes emphasize different aspects of the data, as you can see in Figure 4-16. •    Finally, if you set the "Workgroup templates" folder, you can tell Word and Excel where to look for shared templates. For example, imagine creating a table that stretches from row 1 to row 5. If a chart has multiple series, you'll often find it useful to format them separately to make them easier to differentiate or to emphasize the most important one. 4. You can change the amount of curve in a curved banner, the width of each point in a star, or the length of a line in a callout. To correct Excel's mistake, look for the lightning bolt icon that appears immediately next to the newly added column. The easiest way to do so is to click directly on the element you want to change, as shown in Figure 5-11. Assuming you can find a spot with no data, you get a more compact display. If you want to get rid of a template, right-click it in this window, and then choose Delete. These tricks are remarkably easy to implement, but they rank as one of Excel's best-kept productivity secrets. This fact also explains the existence of some of the shapes that don't make much sense in Excel spreadsheets—they're really intended for other Office applications. You may also want to rotate or tilt the chart so that you have a different vantage point on the data. Sorting and Filtering a Table                                                              1-12, III. In that case, starting over from scratch and creating a template with the exact features you need is probably easier. Once you've finished entering a custom list, click Add to store the list for future use. •    You're just happier in a web browser. In the "Search for" text box, enter a few words that describe the images you want to find. When you first insert a new picture, Excel uses this option—which makes the most sense if you have a picture you want to position near some related data (but you don't want the picture dimensions to get mangled when you add or remove content). This option makes sense if you want to include rich graphics that don't look right on your black-andwhite printer (or just waste too much ink). •    Banded Rows applies different formatting to each second row, if it's defined in the table style. Note: In a 3-D column chart, you'll find an extra setting: Gap Depth. If you have a formula that contains some data that might change (for example, the sales commission, interest rate, late fee, and so on), don't type it directly into your formulas. The difference is in how Excel handles templates. If you click number 1, Excel collapses all the column or row groups. The directions you can use depend on the type you chose in the previous step. A few tricks can help, like reordering the series and simplifying the chart so it isn't cluttered with extraneous data. 7. When you want to create a truly bulletproof template, you can use two more Excel features: •    Data validation prevents people from entering the wrong type of data in a cell (or warns them when they do). A. DOWNLOADING TEMPLATES (METHOD 1: FROM BACKSTAGE VIEW). Figure 4-6.A standalone chart lives in a separate worksheet that doesn't have any other data and doesn't include the familiar grid of cells. And it's almost as easy to put the wrong information in a cell (for example, by entering a date incorrectly so that it's interpreted as text). Which of the following is a benefit to using Excel templates: a)    it is almost impossible to overwrite a template file, b)    templates often contain many advanced features, c)    it is easy to distinguish template files from real spreadsheets because they have a different file extension. Excel lets you do this with the buttons on the ribbon's Chart Tools | Layout tab. Right-click the chart, and then select 3-D Rotation. A chart is a visual representation of data, in which the data is represented by symbols such as bars in a bar chart or lines in a line chart. For example, the records could represent customers, and the fields could contain things like name, address, purchase history, and so on. A basic rectangle has four connection points—one in the middle of each side—and a typical circle has about eight, arranged in even intervals along the border. Both these sections are basically the same. Usually, you'll use this approach to highlight important values. Just select your chart, and then choose Chart Tools | Design?Data?Switch Row/Column. 10. (If you remove a column from the middle of a group, you're actually left with two groups, one with the columns on the left, and one with the columns on the right.). As you've already seen, once you place a template in the Templates folder, it appears in Excel's backstage view, where you can use it to create new workbooks. For example, under the Budget category you'll find templates for personal budgets (family budgets, wedding costs, and even a gardening budget) and templates for business budgets (marketing plan, business trips, operating expenses, and so on). B: Incorrect. For more information about filtering and the ever-impressive table feature, refer to Chapter 1. Data labels are labels that you attach to every data point in a series. For instance, if you have First Name and City columns, you can sort your contacts by first name or by city. When using the SUBTOTAL() function, which codes ignore hidden rows: c)    any function codes you specify to ignore hidden rows, d)    all function codes ignore hidden rows. Pick a color for your shape from the Drawing Tools | Format?Shape. A pivot table is a special type of summary table that’s unique to Excel. It is true that data consolidation works with any sort of tabular data. 3. Here are some tips: •    Clear out the junk. Usually, titles indicate what a chart is comparing or analyzing. Fortunately, Excel offers an easy solution. 3. So what's the difference between an ignored cell and a cell that contains the number 0? C: Incorrect. Open the file Vlookup_Hlookup.xlsx. Any time you're typing text into a shape (or in a floating text box), click the formula bar. If it finds any, it keeps the first copy and deletes those that appear later on in the table. Technically, this latter scenario (shown on the right side of Figure 4-10) should show how yearly sales vary as you move from region to region, but it's just too counterintuitive for anyone to interpret it properly. In both these examples, what's most important is spotting the trends that lurk inside most data collections. Set the line settings, and then click Close when you're finished. It includes similar buttons for applying borders and effects, and arranging and resizing your shape. Choose the Shape section. To select an object, simply click it in the list. A: Incorrect. That's where charts come in handy. You'll also learn which chart types are out there. When you create the table, Excel adds a row of columns at the top with generic names like Column1, Column2, and so on. A simple example shows you the effect. However, different diagrams have different ways of presenting points and subpoints. You'll find this technique particularly handy when you're creating charts that use multiple series, as described later in this chapter. If your table expands too far down, you'll run up against these filled-up cells. Excel doesn't impose any limits when it comes to resizing pictures, and, if you're not careful, you can completely mangle your image. They are included as an additional tool to enhance your learning experience. You can also choose No Fill to make the shape transparent so that other shapes (and your worksheet data) show through. To see these extended column chart settings, right-click a data series in the chart, and then select Format Data Series. But your art skills could make the difference in improving a design. You may use the folder C:\Users\billjones\AppData\Roaming\Microsoft\Templates, but if Sarah Cheng logs onto the same computer, then Excel bothers to check only C:\Users\sarahcheng\AppData\Roaming\Microsoft\Templates. In the "At each change in" pop-up menu, choose the field under which you want the subtotal to appear. English.). If you don't tell Excel where the labels are, it ignores these cells, and the corresponding cells in the summary table wind up blank. 5. The values 0, 10, 20, 30, 40, 50 make up a typical scale. 3. To set a gradient, in the formatting window's Fill section, choose the "Gradient fill" choice. Or, you can check the Chart Tools | Format?Current Selection section of the ribbon. Figure 4-16.The Clustered Column makes it easy to compare the gender of students in each room, but makes it somewhat more difficult to compare different rooms. Most Excel gurus avoid this chart, because it's notoriously difficult to explain. 3. But I don't want to have a workbook that's 30 MB! To make sure Excel handles this omission correctly, you have to enter real date values (rather than text labels) for the category axis. 4. The data series is a single set of data plotted on the chart across the category axis. Some shapes may obscure other shapes. For example, imagine you're trying to limit the product list to show expensive products. On the other hand, if you choose Chart Tools | Layout?Labels?Data Labels?Outside End, the numbers appear just above the top of each column, which is usually more readable (Figure 5-5). An even more interesting pie chart feature breaks down a single slice into more detail. Excel does contain some prebuilt table styles but they are limited, so it is usually more efficient to create your own table style. To get different colors for your tables, you can change the theme by choosing from the Page Layout?Themes?Themes gallery. Obviously, these options may not all apply to a new chart you create based on your template. The columns you create are the basis for all the searching, sorting, and filtering you do. Further down the window, you see options that let you control exactly how Excel tiles your texture. Note: The "New from existing workbook" option is conceptually similar to using a template, in that it creates a new workbook based on an existing workbook file. Excel’s Clip Art Library                                                                               6-16, III. If it says Format Gridlines, you've got yourself a gridline. Custom list sorting works best when you have a relatively small number of values that never change. Ideally, convert values to the same scale (in this case, use the currency exchange rate to turn Euros into U.S. dollars before you create the chart). Note: You can highlight more than one column, but if you do, Excel highlights identical values that appear in more than one column. When you chart a table, you also gain the ability to use other features, like easier sorting and filtering. To use a picture fill, choose the "Picture or texture fill" option, and then click the File button to browse for the picture you want to use. Now, the change has been made. To do so, select the shape, and then choose Drawing Tools | Format?Insert Shapes?Edit Shape?Convert to Freeform. This approach works well if you're grouping multiple columns, but it doesn't work as well if you're grouping rows. All these problems can happen (and regularly do happen), even if you think your template is a small miracle of straightforward design and organization. To change the order of the series, see page 4-22. Watch out for two problems when resizing a typical image. The difference between a texture and an ordinary pattern is that patterns are typically simple combinations of lines and shading, while a texture uses an image that may have greater, more photographic detail. Figure 1-8.You can easily select an entire column in a table. •    The categories under the heading " Templates" let you browse the vast treasure trove of freely downloadable templates that Microsoft provides on its website. •    Use callouts to add descriptive text explaining why a chart line takes a sudden dive or turns upward suddenly. First, tables start out with automatic formatting that gives each row a shaded background (alternating between blue and gray). Excel inserts a new embedded chart alongside your data, using the standard options (which you can fine-tune later). 5. Local templates are custom templates you create yourself. The title labels the whole chart. Note: Lines can never cross in a stacked line chart, because Excel adds each series to the one (or ones) before it. The custom sort feature does work with icon sets, but it can also be used whenever you want to designate a specified text and background colors, so individually, this cannot be the correct answer. Choose a template file from the list by clicking its name. Why not just drag your line anywhere on the border of a nearby shape? C: Incorrect. Figure 6-8.The Clip Art pane is your doorway to the vast resources of clip art on your computer and on Microsoft's Office Online website. This chart is great for emphasizing specific data; it's shown in the next chapter. 4. When you click this button, Excel opens the Insert Picture dialog box (covered on page 6-2) so you can choose the new picture file that you want to use. B: False is correct. You could also use a stock chart to show high and low temperature readings. For example, if the same number appears in the Product ID column and in the Price column, Excel highlights it even though it isn't really a duplicate. It's easy to overwrite the template by accident. Every table starts out with some basic formatting, and you can use the ribbon and the Format Cells dialog box to further change its appearance. By now, you probably realize that templates aren't just a way to eliminate repetitive work when you need to create similar spreadsheets. Stock charts are more rigid than most other chart types. Unless Excel makes a lucky guess, this selection doesn't include the same slices that you want. 5. •    Line with Markers, Stacked Line with Markers, and 100% Stacked Line with Markers. Bottom: This chart's data labels have been removed from the X-axis, and category labels have been added to the whole data series so the region's name shows up just below the bar. Pie charts are one of the simplest types of charts, and one of the most recognizable. You'll see a variety of different types of dashed and dotted lines. If you select part of the text, a mini bar appears (sadly, of the alcohol-free variety), with formatting options for changing the font, size, color, and alignment. If you have too many columns in a column chart, Excel has a hard time fitting all the column labels into the available space. To use a template, begin by selecting File?New. You can fix this problem by adding additional labels or a legend. But these high-contrast styles look good on computer monitors and projection screens, so use them if you want to cut and paste your chart into a PowerPoint presentation. Do you have a question about the Microsoft Excel 2010 or do you need help? However, in many situations you may want to try several chart types with the same data to see which visualization tells your story better. C: Incorrect. One interesting trick is to use the overlap setting to compare two sets of data. You can save a template file anywhere on your computer, and open it later by browsing to the right folder, and then choosing the template file. Unlike the orderly rows of numbers and labels that fill most worksheets, charts float above your data, locked inside special box-like containers. Excel templates are spreadsheets that have been predesigned with several beneficial features. To try this out, choose, Insert?Illustrations?Screenshot, and then pick the window you want from the list of thumbnails. If you want to ignore the hidden cells in collapsed groups, you have to use the calculation codes above 100. You may add a chart title like "Patio Furniture Sales" and the axis labels "Gross Revenue" and "Month of Sale" to a chart that shows how patio furniture sales pick up in the summertime. Instead of entering text labels, you can enter actual dates or times. •    To hide just a few items, click the eye icon next to each item in the Selection and Visibility pane list. The Highlight Duplicates feature ignores empty cells and doesn't highlight them. When you've finished making your changes, click OK. Excel applies the results of your artistry. In fact, you can create everything from simple shapes to complex art without leaving your worksheet. Since this is an intermediate level Excel course, it does not cover the basics of working with rows and columns or entering data or formulas into a spreadsheet. (You'll learn about how to manage these multi-tiered creations in the next chapter.) Selecting a data point is a little tricky. You can build formulas that use the data in a table, and Excel adjusts them automatically as the table grows or shrinks. Excel has no restriction on linking multiple charts to the same data. By default, Excel offers to save the chart template in a Chart subfolder inside your personal template folder (page 3-11). Select the table column (as described on page 1-11) that you want to check for duplicate values. •    If you change the "User templates" folder, you can specify where Excel and Office look for user-created templates stored on your computer. The contrast is a measure of how much difference exists between the brightest and darkest colors. For instance, Remove Duplicates treats repeated empty cells (blank values) as duplicates, and removes them. However, you create a much more dramatic effect by putting more than one shape in a single chart. Choose the type of line you want. You can use it to build new spreadsheets. Excel treats all blank cells as though they contain the number 0. Sometimes, you'll want to select several shapes at once. Many template novices assume that templates are a special sort of file that's similar to Excel spreadsheets. 1. The second issue to be aware of is aspect ratio—the ratio of an image's width to its height. Any information in the same row that exists outside the table is unaffected. Under the "Object positioning" section, choose one of the options. Excel sorts these values alphabetically, which means it looks at the text string one character at a time until it finds a difference. Then, click the rightmost edge, and drag it to the right to expand the range so that it includes the new columns (which, of course, you've already added to your worksheet). 7. If that's the case, you'd need to add your own formulas, restrictions, and formatting to the template. 2. The Select Data Source dialog box appears (Figure 4-14). In the first table (left), the category axis lists the sales years, which are used to group the regions. Otherwise, the totals appear at the beginning of the group. A: True is correct. Since colors and fills are limited only by the imagination, it is best to use as much flare and color as possible when charting. Category axis scaling works with more than just dates. When does it make sense to add additional levels of sorting beyond your primary sort: b)    only if there is a possibility of duplicate values in the levels you have already created, c)    whenever you have four or more columns. Selecting Chart Elements       5-13 IV. If you put them side by side, the database function just gives you an error. A: Incorrect. Unfortunately, Excel isn't always particularly forgiving. Because of this difference, the area chart tends to emphasize the sheer magnitude of values rather than their change over time (see Figure 4-19). You make a combination chart by creating a new secondary value axis. Choose Data?Sort & Filter?Sort, and then add three rules, as shown in Figure 1-14. Once you've chosen the calculation code, you need to specify the cells or range of cells you want to add. In simple charts, data series labels work well. Excel doesn't provide any ready-made pictures. Create a PivotTable with the Data Model to analyze data in multiple tables B: False is correct. That means you need to remove the Computer entry and replace this information in the chart with more detailed information. See Figure 4-17 for an example. 7. Excel also provides the Cylinder, Cone, and Pyramid chart types, which are always threedimensional (see the description of chart types, beginning in “Column,” for more information). In a line chart a 0 value is plotted on the chart, but an empty cell causes a break in the line. However, because this cell is currently blank, Excel doesn't apply a price filter. Tip: To remove a chart in one fell swoop, just select it with the mouse, and then press Delete. B: False is Correct. In fact, all Excel really does is shrink each of these rows to have a height of 0 so they're neatly out of sight. In other words, the line stops just before the missing data, and then starts again at the next point. Although charts appear to float above the worksheet, they're actually anchored to the cells underneath. A texture is a detailed pattern that's tiled over the whole chart element. The minimum and maximum values set the range for the scale. Or a researcher might look at a set of scientific data to find out if potatoes really can cure the common cold. Which of the following table elements is not included in the Table Style Options: 4. One of the easiest ways to spot a trend is to add a trendline to your chart. Your only other option is "Gradient line", which lets you create a line that's painted with a gradient fill of colors (page 518). These options work the same way they do when you format the whole series, except now they apply only to the currently selected value. Table 1-2 lists the database functions, along with comparable statistical function. 6. Bottom: Here's the mess that results if you add data labels to the whole Region 1 and Region 2 series. A: Incorrect. Trying to pack as much information as possible into a chart—without cluttering it up—is a real art form. Calculates the standard deviation in rows that meet the specified criteria. Automatic outlining is an all-or-nothing affair, giving you either a grouped worksheet or the unhelpful error message, "Cannot create an outline". This chart's problem is that the difference between the column values doesn't come across as very substantial—but, in fact, it is. After all, Excel would have no idea what row you're trying to use. You'll rarely want to remove this option. The category is the room name, and there are two data series: the numbers of male students, and the numbers of female students. In other words, once you add a formula to a column, that formula is sticky. These shapes look best if you put some text inside them. But if your boss is out of the office and you need to fill the next hour, go ahead and experiment! Note: There's a little-known trick you can use to put a cell reference into the text of shape. The reason this odd feature exists may never be entirely clear. Note: If you use Excel's point-and-click formula creation, Excel uses the column names rather than the cell reference. You can use several strategies to get around this problem. For example, if you have a bunch of products in the Communications category, then they appear in whatever order they were in on your worksheet, which may not be what you want. 2. Most importantly, databases play a dramatically different role in the world of business. Then choose Home?Cells?Delete?Delete Table Rows. In this case, select the series by name from the Chart Tools | Format?Current Selection list. The menu provides a list with all the column titles in your selection. To choose a style, select the chart, and then head to the ribbon's Chart Tools | Design?Chart Styles section, which gives you a gallery of choices (Figure 5-1). To rotate or tilt a chart, follow these steps: 1. 3. They add the value from the cell that Excel used to calculate the bubble size next to each bubble. Then, select Series Options, which is the first section in the list. This axis appears on the right side of the chart. Earlier in this chapter, you learned how to create a new workbook by choosing a template in backstage view. To do so, head to the ribbon's Insert?Charts section, and then click the dialog launcher (the square-with-an-arrow icon in the bottomright corner). Standalone charts, which occupy separate worksheets, always print on separate pages. Surface charts are different from most other charts in that they show the relationship of three values. If you insert new rows above the picture, the whole picture shifts down. Most of the time, it is not worth creating your own table style because it is simply too much work and the prebuilt table styles have a good selection of formatting choices. B: Incorrect. •    Major unit. Excel uses this text to create the diagram. Excel suggests a name based on the name of the template. Finally, choose a new resolution from the "Set default target output to" list. 4. In this case, Excel just ignores any formatting information it isn't using. Figure 5-7.Here's how you can combine percentage and category information to make a pie chart more readable and eliminate the legend altogether. Most organizations and businesses maintain a group of templates that define things like standard layout and formulas for common types of spreadsheets like invoices and expense reports. For example, if you're using DSUM(), the field is the numeric column you want to total. The only difference is that they're stored in a shared location where more than one person can access them. Figure 1-12.The worksheet shows the following sort's result: alphabetically ordered categories, each of which contains a subgroup of products that are themselves in alphabetical order. Interpolation:  The process of estimating unknown data values between known existing values. Figure 2-11 shows the result. Figure 1-21.This worksheet shows a new column with a formula that's in the process of being entered. The scroll bars (circled) let you move through the style options not currently shown, or click the down arrow to see a drop-down window with all your choices. In the "Results should be" list, you can choose the media types you want to search for. They're particularly useful when you don't want to connect every dot with a straight line.

Hp Elitebook 840 G5 Gaming, Arcadia, Fl Zip Code, Contech Ct-600 Price, City College Courses Offered, Moorhen And Coot Difference, Whirlpool Wrf767sdhz Reviews, Aqa A Level Chemistry Past Papers, Baby Pheasant Food, Windows 10 Ultimate Performance Mode Gaming,

Pas de commentaire pour l'instant

Ajouter le votre !

Laisser votre commentaire