Microsoft Office Tutorials and References
In Depth Information
6. Press Enter.
You can apply any type of formatting you like to the text box.
After you add a text box to a chart, you can change it to any other shape that supports
text. Select the text box and choose Drawing Tools ⇒ Format ⇒ Insert Shapes ⇒ Edit
Shape ⇒ Change Shape. Then choose a new shape from the gallery.
Adding a linked picture to a chart
A chart can display a “live” picture of a range of cells. When you change a cell in the linked range, the change
appears in the linked picture. Again, the process isn't exactly intuitive. Start by creating a chart. Then:
1. Select the range that you want to insert into the chart.
2. Press Ctrl+C to copy the range.
3. Activate a cell (not the chart) and choose Home ⇒ Clipboard ⇒ Paste ⇒ Linked Picture (I).
Excel inserts the linked picture of the range on the worksheet's draw layer.
4. Select the linked picture and press Ctrl+X.
5. Activate the chart and press Ctrl+V.
The linked picture is cut from the worksheet and pasted into the chart. However, the link no longer func-
6. Select the picture in the chart, activate the Formula bar, type an equal sign, and select the range again .
7. Press Enter, and the picture is now linked to the range.
This section contains a variety of chart examples that you may find useful or informative. At the very least, they
may inspire you to create charts that are relevant to your work.
Single data point charts
Effective charts don't always have to be complicated. This section presents some charts that display a single
A workbook with these examples is available at this book's website. The filename is
single data point charts.xlsx.