How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

How to Make a Legend Box Bigger in Excel. A legend box in an Excel chart lists the chart's data series. It specifies each series' name and the color of its marker on the chart.

Consequently, if you hide worksheet data, Excel won’t display that data in a chart. For instance, it’s obvious from a quick look at the following chart’s legend that Tuesday’s data is missing: ...

When the relationship between the charted entities is less important than the individual entities, try using these two chart techniques to highlight important details in Microsoft Excel.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.