Uncategorized

Insert chart title excel 2008 mac

To get to it, double click on the vertical axis and the Format Axis dialogue box will appear. Remember that the axis is overlaid on the chart area, so make sure you are actually on the axis when you click. You can tell when the axis is selected because light blue dots will appear on the corners. Alternatively, you can reach this dialogue box by going to the Format tab or the Layout tab under the Charts toolbar and selecting Vertical Value Axis from the dropdown menu found at the top of the Current Selection group far left of the Ribbon.

How do I insert a text box in a chart (excel 2011)?

Then select Format Selection. One of the single most important things to know about graphs is how to alter the size of the vertical axis. Such a simple change can greatly alter the appearance of data and potentially the interpretation. The Minimum , Maximum , Major unit , and Minor unit will always be defaulted to Auto , however, you can change the values in the text boxes thereby altering the size of the vertical axis.

Here we changed the Minimum from 0 to and the Major unit to which increased the number of gridlines. Be sure to note that the Major unit can never be smaller than the Minor unit. I could alter the axis to focus in on those three.

Create axis titles for your Excel 2007 charts

The apparent pattern changes when we zoom in. Of course, if I wanted to present these changes I would also remove the other data points returning to Select Data and re-selecting the relevant data. As with the horizontal axis options, you can alter the Major tick mark type , Minor tick mark type , and the Axis labels. Again, use your discretion when experimenting with these features. Alignment allows you to change the alignment of the text as well as the orientation horizontal, rotated, stacked.

With all of the formatting options in the Format Axis dialogue boxes for the vertical and horizontal axes, they do not allow you to add axis titles.


  1. java 7 update 45 for mac!
  2. adobe photoshop cs6 trial for mac;
  3. mac os x 10.7 vpn server setup.
  4. cs5 web premium mac download trial.
  5. fleetwood mac bad loser lyrics.
  6. scaricare musica gratis col mac.
  7. mac economizer 2000 top box!

To add axis titles you must go to the Layout tab under the Charts toolbar and select Axis Titles in the Labels group. As with the chart title, after selecting insert we can type the title in the formula bar and after pressing ENTER it will appear where the box currently says Axis Title. There are many options for formatting changes which I encourage you to explore.

Video of the Day

You can move the axis titles or delete them just like with chart titles. Questions, comments, concerns? Microsoft changed the way axis labels are added to graphs in Excel for Mac. For people familiar with previous versions of Excel, the new process can be unintuitive at first.


  1. How to Add Axis Labels and Titles to Charts in Excel @ jammer(six);
  2. m4v to dvd converter for mac free download.
  3. Barnard Library and Academic Information Services (BLAIS).

Read on to learn how. To create this article, volunteer authors worked to edit and improve it over time.

Chart titles in Excel - Mac Office Excel

This article has also been viewed 85, times. Microsoft Excel. Learn more.


  1. traktor scratch pro 2 crack for mac os.
  2. How to Add Axis Labels and Titles to Charts in Excel 2008.
  3. Making a graph in Excel | MacRumors Forums!
  4. Formatting Chart Axes (Mac);
  5. Authoring Techniques for Accessible Office Documents: Excel 2008 for Mac!

Learn more Create your graph as normal. Make sure the formatting palette is visible. If it is not visible, select it under the "View" menu.

Excel 2007 Just the Steps For Dummies

On the formatting palette, select "Chart Options" by clicking on the down arrow. In the "Titles" select the X or Y axis as desired from the pop-down menu.

Adding custom error bars in Mac Excel 2008

Type your axis label in the box below the menu. Click on the newly created axis label, and then adjust size or font if desired in the formatting palette.