DynamicTitleandLabel

DynamicTitleandLabel - CreatingADynamicChartTitle...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Creating A Dynamic Chart Title and a Dynamic Legend Microsoft Excel 2000 and XP
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Creating A Dynamic Chart Title and a Dynamic Legend How to Create a Dynamic Chart Title: 1. Create the chart as usual, without a title. 2. In a cell of the worksheet use the CONCATENATE function Sales person: Jim Doe     that formula is in Cell C9. 3. Select the Text Box from the drawing toolbar and draw a Concatenated string: Sales by Jim Doe for January - March     small box in the chart title area. 4. With your cursor inside the text box, click IN THE FORMULA BAR January February March     and enter the cell reference for the concatenated string. Here, C9. A 10 12 15 5. Depress the SHIFT key and hit the ENTER key.  B 22 18 12 The concatenated text string is entered into the text box chart title. C 34 35 38 Change the elements of the string and the title automatically changes.
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 2

DynamicTitleandLabel - CreatingADynamicChartTitle...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online