When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data. Sometimes a chart’s underlying data doesn’t fit in the chart window. When ...

Turn generic columns into custom visuals by adding floating totals, nesting series, and layering simultaneous data labels.

When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same color by default. Another way to display the chart is to change the color of the ...

Viewing the distribution of related values from one entity to another is a frequent request, and that’s where Microsoft Excel floating bar charts can help. Instead of starting from the X axis, the low ...

One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance, you ...