How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

How do you flip a chart left to right in Excel? Right-click any of the axis on the chart and select Format axis on the menu. A Format Axis pane will open. Under the Axis Options, in the Axis ...

To do this, right-click the chart’s Y-axis and choose Format Axis > Number tab. Click on Custom – as you can see, you can create custom formats for chart axes too. In the Type box, type the following ...

Graphs in Microsoft Excel typically chart time on the horizontal axis. Time is the independent variable in most relationships and dependent variables appear on the vertical axis. Some charts ...

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings.

ADJUST THE AXIS SCALE ON AN EXCEL CHART Excel usually does a good job second-guessing me when it chooses the scale for an axis on a chart. But sometimes, to better focus some data, I need to adjust ...

Learn how to create Gantt charts in Microsoft Excel spreadsheets to provide visual representations of your data for easy analysis and ...

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

When you use Excel's Chart Wizard to create a chart, by default the chart takes on the number formats used in the worksheet that includes the charted data. Mary Ann Richardson shows you a way to ...

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.

Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart.