Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of ...

That’s because the chart, by default, references a specific data range, DynamicChart1:A1:E3. We need to change that reference to the dynamic ranges we just created, as follows: ...

Click the range option and enter the cell range of the data you want to chart. (For example, if the data you want to chart is located in cells A3 through D7 of the Excel worksheet, enter A3:D7.) ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

To create a variance chart in Excel, begin by selecting the data range that includes both the actual and target scores. For a quick start, use the keyboard shortcut Alt + F1 to generate a basic ...

In Microsoft Excel, you can create a Half Pie Chart if your data range has a total. A Half Pie Chart is a 180 degrees graph that represents a composition as a whole.

Once you've mastered some of the more straightforward Excel charts, try using some that offer more specific functions and data visualization.