if you want to remove an article from website contact us from top.

    which tools would you use to make chart 1 look like chart 2 select all that apply

    Mohammed

    Guys, does anyone know the answer?

    get which tools would you use to make chart 1 look like chart 2 select all that apply from screen.

    Solved QUESTION 12/15 Which tools would you use to make

    Answer to Solved QUESTION 12/15 Which tools would you use to make

    © 2003-2022 Chegg Inc. All rights reserved.

    स्रोत : www.chegg.com

    Present your data in a bubble chart

    A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles. Just like a scatter chart, a bubble chart does not use a category axis — both horizontal and vertical axes are value axes. In addition to the x values and y values that are plotted in a scatter chart, a bubble chart plots x values, y values, and z (size) values. You can use a bubble chart instead of a scatter chart if your data has three data series that each contain a set of values.

    Present your data in a bubble chart

    Excel for Microsoft 365 Excel 2021 Excel 2019 More...

    You’re invited to try Microsoft 365 for free

    Unlock now

    A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles. Just like a scatter chart, a bubble chart does not use a category axis — both horizontal and vertical axes are value axes. In addition to the x values and y values that are plotted in a scatter chart, a bubble chart plots x values, y values, and z (size) values.

    Newer versions Office 2007 – 2010

    Create an elaborate bubble chart

    So, how did we create this bubble chart? The following procedure will help you create a bubble chart with similar results. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data.

    Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot in a bubble chart.

    To copy the example worksheet data

    Create a blank workbook or worksheet.

    Select the example in the Help topic.

    Note: Do not select the row or column headers.

    Press CTRL+C.

    In the worksheet, select cell A1, and press CTRL+V.

    A B C 1

    Number of ProductsSalesPercentage of Market Share

    2 5 $5,500 3% 3 14 $12,200 12% 4 20 $60,000 33% 5 18 $24,400 10% 6 22 $32,000 42%

    Note: Make sure that your worksheet has at least four rows or columns of data. When you create a bubble chart from three or fewer rows or columns of data, the chart does not plot the bubbles correctly.

    Select the data that you want to plot in the bubble chart.

    Note: It is best not to include row or column headings in the selection. If you select the headings with your data, the chart may produce incorrect results.

    On the Insert tab, in the Charts group, click the arrow next to Scatter Charts.

    Select the bubble with the 3-D effect icon.

    Click the chart area of the chart. This displays the Chart Tools.

    Under Chart Tools, on the Design tab, in the Chart Styles group, click the chart style that you want to use.

    If you see a legend on the chart, click the legend, and then press DELETE.

    To change the size of the chart, on the Format tab, in the Size group, select the shape size that you want in the Shape Height and Shape Width box, and then press ENTER.

    For our bubble chart, we used 3.5" for both shape height and shape width.

    To format and position a chart title on the chart, click the chart area, and then do the following:

    In the chart, click the chart title, and then type the text that you want.

    For our bubble chart, we typed Industry Market Share Study.

    To reduce the size of the chart title, right-click the title, select Font, and then enter the size that you want.

    For our bubble chart, we used 12.

    To align the chart title with the plot area, click the chart title, and then drag it to the position that you want.

    To add a horizontal axis title, click the chart area of the chart, and then do the following:

    Click the plus sign next to the chart

    Select Axis Titles, and then select Primary Horizontal.

    Select the Axis Title text box, and then enter your text.

    For our bubble chart, we typed Number of products.

    Click the vertical axis, or select it from a list of chart elements (Format tab, Current Selection group, Chart Elements box).

    On the Format tab, in the Current Selection group, click Format Selection.

    Under Axis Options, do the following:

    For Minimum, type 0 (zero).

    For Maximum, type the number that you want.

    For our bubble chart, we typed 80000.

    In the Format Axis dialog box, click Number.

    Under Number, in the Decimal places box, type 0 (zero), and then click the down arrow in the upper-right corner, and click Close.

    To apply a special formatting effect to the plot area, chart area, chart title, or vertical axis of the chart, click that chart element, or select it from a list of chart elements (Format tab, Current Selection group, Chart Elements box), and then do the following:

    On the Format tab, in the Shape Styles group, click the More button next to Shape Effects.

    Click the effect that you want to use.

    If you want to use theme colors different from the default theme that is applied to your workbook, do the following:

    स्रोत : support.microsoft.com

    Using Tables and Charts Flashcards

    Study with Quizlet and memorize flashcards containing terms like Why is it important to put the insertion point in the table when sorting table data?, Which object tells Word that a formula is being entered into a cell?, Which command group does a user need to access the Formula dialog box? and more.

    Using Tables and Charts

    5.0 (31 reviews) Term 1 / 13

    Why is it important to put the insertion point in the table when sorting table data?

    Click the card to flip 👆

    Definition 1 / 13

    This action opens Table Tools, which contains the sorting feature.

    Click the card to flip 👆

    Created by manugavassi45

    Terms in this set (13)

    Why is it important to put the insertion point in the table when sorting table data?

    This action opens Table Tools, which contains the sorting feature.

    Which object tells Word that a formula is being entered into a cell?

    equal sign

    Which command group does a user need to access the Formula dialog box?

    Data

    What is the purpose of the Chart feature in Word?

    Information can be typed into a chart to create a graph.

    Which tasks can be completed using the Chart Tools Design tab? Check all that apply.

    add a title to a chart

    change the way a chart looks

    change the type of an existing chart

    How can an Excel table be added to a Word document? Check all that apply.

    by using the Insert Object dialog box

    by linking an Excel table to a Word document

    Gemima wants to order the different kinds of food alphabetically on the table. Which actions should she take? Check all that apply.

    Click inside the table.

    Click on the Sort icon.

    Choose the Header Row option in the Sort dialog box.

    After sorting the data, Gemima wants to add a title row to her table.

    Order the steps Gemima needs to take to add the title in a single cell at the top of the table.

    Step 1: Put the cursor in the Food Cell

    Step 2: Insert a row above the header icon

    Step 3: Click the Merge Cells icon

    Step 4: Type the title in the cell

    Gemima wants to show the amount of vitamin C a fruit salad contains in the blue cell of the table below. To do this, she needs to open the Formula dialog box.

    Which tab should Gemima use to open the Formula dialog box?

    Which command group should she use?

    Which icon should she click?

    Layout, Data, Formula

    Gemima now has the Formula dialog box open.

    Which formula should Gemima use to show the amount of vitamin C in the fruit salad?

    =SUM(ABOVE)

    Which step should Gemima fix to complete the task correctly?

    Step 4

    Gemima has converted her table to a clustered column chart. She now wants to add a title.

    What should Gemima do first?

    What should Gemima do next?

    What should Gemima do last?

    Select the table, Use Ctrl+A, Type the title.

    Gemima's classmate Tristan sent her an Excel table that shows the amount of vitamin C in seafood. She wants to paste this table to her Word document.

    Which pasting option should she use so that the updates in the Excel table are reflected in her Word document? Check all that apply.

    Link and Use Destination Styles

    Link and Keep Source Formatting

    Students also viewed

    Letters Envelopes and Labels

    23 terms eep38

    Controlling Content Flow

    5 terms mk21273

    Controlling Content Flow

    8 terms luthoredits

    word unit exam 14/16

    16 terms emmani1122

    Sets found in the same folder

    20/21_GRPS_ELECTIVE_Computer Applications - O…

    114 terms

    hayden_riley_tarbell

    Standardizing Documents Using Styles

    12 terms manugavassi45

    word unit test 24/25

    25 terms emmani1122

    Letters Envelopes and Labels

    23 terms eep38

    Other sets by this creator

    Microsoft Office Specialist - Office 2016

    76 terms manugavassi45

    Analyzing Rhetorical Strategies in Presidenti…

    18 terms manugavassi45

    Analyzing Rhetorical Techniques in Machiavell…

    12 terms manugavassi45

    Analyzing Ideas, Structure, and Purpose in Ma…

    10 terms manugavassi45

    Verified questions

    Other

    why do you think young people turn to music to express their differences from their parents' generation?

    Verified answer Other

    Drawings using ___ dimensioning usually show objects that do not require a high degree of precision in their manufacture.

    Verified answer Other

    Which of the following activities can cause your BAC to rise quickly: A. Playing drinking games B. Drinking shots C. Pregaming D. All of the above

    Verified answer Other

    Which religion has the most followers worldwide?

    Verified answer

    Other Quizlet sets

    Initial Medical Response

    13 terms steven_martino Keynote unite 3 21 terms elinmess

    acct quiz 9 (chapter 12)

    10 terms gabtothegabber K Midterm 55 terms FallingStar27 1/5

    स्रोत : quizlet.com

    Do you want to see answer or more ?
    Mohammed 1 month ago
    4

    Guys, does anyone know the answer?

    Click For Answer