Once you've identified the part of your chart you want to format, Excel presents a range of icons for you to click. Which icons you see depends on which part you've selected to format.

How to Change the X-Axis Range in Excel Charts. For a business owner, Microsoft Excel 2010 provides an excellent platform for storing numerical information about your business.

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

However, your Excel 2013 spreadsheet might also use named ranges that never change unless you manually adjust them. Changing these ranges apply to all formulas that use the named range. Changing ...

Click OK and Excel will format the data range as a table. Any chart you build on the table will be dynamic. To illustrate, create a quick column chart as follows: ...

Name a range using the Formulas tab in Excel Naming a range from the Formulas tab is one of the best ways to get the job done, so if you’re not sure how, well, let us take the time to explain.