Excel 2007's secondary axis feature enables you to view two different data series with two distinct scales, all on the same chart. Use this feature to view your business' sales and inventory figures ...

The X-axis, which is the horizontal axis, on most Excel charts does not use numeric intervals like the vertical Y-axis does. The X-axis contains either strings of text or a date under each set of data ...

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings. If an Excel chart’s vertical axis is incremented by 20,000, and most of its ...

Please note: This item is from our archives and was published in 2007. It is provided for historical reference. The content may be out of date and links may no longer function. Excel usually does a ...

Forbes contributors publish independent expert analyses and insights. I help people communicate data clearly with graphs. The solution is simple: interchange the axes to use a horizontal bar chart ...

Excel’s REPT function is a hidden gem that can transform your bar charts from ordinary to extraordinary. This function allows you to repeat text a specified number of times, allowing you to simulate ...

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it’s as easy as creating a table. In earlier versions, you’ll need the formula method.

If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same ...

The scale on the left graph is inappropriate. The numbers go up higher than necessary on both axes. This means the points are squashed into a small part of the graph area and are difficult to read ...