Tips, Tricks, and Answers
The following articles are available for the 'Creating Charts' topic. Click the article''s title (shown in bold) to see the associated article.
Automatically Creating Charts for Individual Rows in a Data Table
If you have a lot of records in a data table, you may want to create individual charts based on the information in those records. This can be done by applying the techniques described in this tip.
Controlling the Plotting of Empty Cells
When creating a chart from information that contains empty cells, you can direct Excel how it should proceed. This tip explains the process.
Easily Changing Chart Data Ranges
Want a handy way to make the data ranges for your chart more dynamic? Here are some great ideas you can put to work right away.
Make that Chart Quickly!
Need to generate a chart in the fastest possible way? Just use this shortcut key and you'll have one faster than you can yell "chart!"
Moving Groups of Data Labels at One Time
Having problems working with data labels in your charts? That's not unusual; here's an idea of an add-in that could help you manage those labels better.
Multiple Data Points in a Chart Column
Excel provides lots of ways you can create charts. This tip provides some pointers on how you can combine stacked column charts and clustered column charts in ways you may not have been aware of.
Numeric Value and Percentage Value in a Graph Column
Need more than a single data label on a data series? Here's a relatively easy way to get what you need.
Specifying Chart Sizes
If you need a number of charts in your workbook to all be the same size, it can be a bother to manually change each of them. Here's a way you can make quick work of sizing all those charts.
Specifying the Size of Chart Objects
Unhappy with the default size that Excel uses for embedded chart objects? You can't change the size at which they are originally created, but you can use the techniques in this tip to resize them all at the same time.