Which of these series of clicks will you use to promote a shape in an Excel sheet

To open Numbers, click the Numbers icon in the Dock, Launchpad, or the Applications folder.
Inhaltsverzeichnis Show
If the template chooser (shown below) doesn’t appear, click New Document in the bottom-left corner of the dialog. You can also hold down the Option key and choose File > New (from the File menu at the top of your screen).
Note: If you’d like the ability to format table and chart data using the conventions of another language, choose the language in the bottom-left corner before choosing a template. See Format a spreadsheet for another language.
In the template chooser, browse templates by category or click All Templates, then double-click a template to open it.
To create a new spreadsheet from scratch, double-click the Blank template.
Do any of the following:
- Add your own headers and data to a table: Select a table cell, then type.
- Add other tables, text boxes, shapes, and images: Click object buttons in the toolbar.
- Arrange elements on the sheet: Drag tables and objects to where you want them.
To name and save your spreadsheet, choose File > Save, enter a name, choose a location, then click Save.
If iCloud Drive is set up on your Mac, Numbers saves the spreadsheet there by default.
You can change the name of the spreadsheet or change its location at any time.
To close the spreadsheet when you’re finished working, click the red close button in the top-left corner of the window.
Numbers automatically saves your changes, so you won’t lose any of your work.

Watch Video – Highlight Data Points in Excel with a Click of a Button

A chart gets difficult to read if it has a lot of data plotted on it. While it is a good practice to plot only the relevant data, there are situations where you need to show a lot of data points on a single chart.

If you are stuck in such a situation, it is a good idea to have a dynamic chart that highlights the selected series so that it is easier to read and compare. Something as shown below:

In the above chart, when you click on the button, the selected year’s series gets highlighted with red marker outline and the data labels.

Follow Along.. Download the Chart

Highlight Data Points in Excel Line Chart

Here is how you can create this type of charts:

Get the data in place. For this chart, I have Revenue Growth numbers for each quarter during 2012-15.
Select the entire data, go to Insert –> Charts –> Line with Markers. This would insert a line chart with three different lines for each year.
Go to Insert –> Illustrations –> Shapes –> Rounded Rectangle. Click anywhere on the worksheet and it will insert a Rounded Rectangle in the worksheet.
Insert 2 more Rounded Rectangles and place it over the chart. Enter the Series Name (years) in the shapes as shown below:
Select the rectangle for 2013, go to Name Box and enter 2013. Similarly, do the same for 2014 and 2015 boxes as well (Name Box is at the left of formula bar).
In cell F2, enter 2013 (you can enter any year from the data).
In cell F3, enter the following combination of INDEX, ROWS and MATCH functions (and drag it for cells F3:F6)
```
=INDEX($B$3:$D$6,ROWS($E$3:E3),MATCH($F$2,$B$2:$D$2,0))
```
Select cells F3:F6 and copy it (press Control + C), select the chart and paste (control + v). This would create two lines for the same year (while copying, notice that the line color of the selected year changes).
Select the line for the year (for which you copied the data), right click and select Format Series Data. In the Format Data Series:

If you have followed all the above steps, you would have something as shown below:

Now to make the buttons functional, we will use a simple VBA code.

The VBA code

We will use VBA code to do 2 things:

Change the year value in cell F3 when the shape is clicked, and
Change the color of the selected shape

Simply copy the following code in the VB Editor.

Sub SelectYear2013()
Range("F2").Value = 2013
ActiveSheet.Shapes("2013").Fill.ForeColor.RGB = RGB(176, 196, 222)
ActiveSheet.Shapes("2014").Fill.ForeColor.RGB = RGB(255, 255, 255)
ActiveSheet.Shapes("2015").Fill.ForeColor.RGB = RGB(255, 255, 255)
End Sub

Sub SelectYear2014()
Range("F2").Value = 2014
ActiveSheet.Shapes("2013").Fill.ForeColor.RGB = RGB(255, 255, 255)
ActiveSheet.Shapes("2014").Fill.ForeColor.RGB = RGB(176, 196, 222)
ActiveSheet.Shapes("2015").Fill.ForeColor.RGB = RGB(255, 255, 255)
End Sub

Sub SelectYear2015()
Range("F2").Value = 2015
ActiveSheet.Shapes("2013").Fill.ForeColor.RGB = RGB(255, 255, 255)
ActiveSheet.Shapes("2014").Fill.ForeColor.RGB = RGB(255, 255, 255)
ActiveSheet.Shapes("2015").Fill.ForeColor.RGB = RGB(176, 196, 222)
End Sub

To copy this code:

Press Alt + F11. It will open the VBE Editor.
Go to Insert and click on Module. This will insert a module.
Double click on module icon, and paste the code on the code area on the right.

Assign Macros to Buttons

Once you have the VBA code in place, you need to assign macros to the buttons/shapes. To do this:

Right-click on the shape and select Assign Macro.
In the Assign Macro dialog box, select the macro and click OK.

Note: Since this workbook contains a macro, save it as a .xlsm or .xls format file.

Now your dynamic chart is ready. With a single click, you can now highlight data points for the selected series.

Download the file

More on Dynamic Excel Charting Tutorials:

Dynamic Pareto Chart in Excel.
Dynamic Target Line in Excel Bar Charts.
Spot the Data Point in Excel Scatter Chart.
Dynamic Chart with Series Selection Check Box.
How to Create Dynamic Chart Titles in Excel.

Which of these series of clicks will you select to add text to a smart art?

Insert a SmartArt graphic and add text to it On the Insert tab, in the Illustrations group, click SmartArt. In the menu of types that appears, point at the type you want and then select a layout. Enter your text by doing one of the following: Click [Text] in the Text pane, and then type your text.

How can you add a new picture to a SmartArt graphic?

Insert pictures in SmartArt Select More SmartArt Graphics and then select Picture. Select the SmartArt you want and select OK. To insert a picture, select the picture icon, go to where your picture is located, and then select it. Select Insert.

Which of the following can you apply to change the way a SmartArt graphic looks?

You can change the look of your SmartArt graphic by changing the fill of its shape or text; by adding effects, such as shadows, reflections, glows, or soft edges; or by adding three-dimensional (3-D) effects, such as bevels or rotations.

Which of the following can you use to insert a picture in a SmartArt shape?

How can you add a new picture to a SmartArt graphic? Select a picture, click the Insert tab under Picture Tools, click the Insert Picture, and then select a layout.