Embedded Charts

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

When you create a chart embedded as a ChartObject, it is a good idea to name the ChartObject so that it can be easily referenced in later code. When you select the chart, you will see its name to the left of the Formula bar at the top of the screen in the name box.

You can select and change the name of the ChartObject in the name box and press Enter to update it. The embedded chart in Figure 8-4 was created, dragged to its new location, and had its name changed to MangoesChart. The name can also be changed in the Layout tab of the Ribbon by clicking the Properties button.

Excel 2007 Userforms Charts
Figure 8-4

The chart was created, using the Insert tab of the Ribbon, by clicking the Column button and selecting the top-left chart type from the 2-D Column section of the resulting dialog box. The name was changed in the name box. The row/column orientation was switched in the Design tab as before. The title was added by activating the Layout tab of the Ribbon and clicking the Chart Title button in the Labels group and choosing Centered Overlay Title.

Was this article helpful?

+1 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment