Excel.Tips.Net ExcelTips (Menu Interface)

Creating Charts

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.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2017 Sharon Parq Associates, Inc.