When you create a graph in Microsoft Excel 2010, the axis labels and legend titles are drawn from the information in the cells surrounding the data. However, if you have subscripts or superscripts in the text in those cells, they will not transfer over to the graph, making the text in the graph appear wrong. You can edit the fonts for most of the text on your graph, but if you need to include subscripts in the axis labels or your legend, you'll have to use text boxes over the chart text, as you can't alter only part of these labels. Right-click in the text box and choose 'Size and Properties' from the pop-up menu.
Click the 'Fill' option on the right side of the window that appears, then click the radio button next to 'Solid Fill.' Click on the paint can icon that appears and click the white color from the palate. Drag the slider under transparency all the way to the left. The click the 'Properties' option on the left side of the window.
How do I show number labels on the minor division of the Y axis in Excel 2011? For example, between 1,000 and 10,000 on the chart below, can I add labels like 3000, 7000, 8000 to the axis? Mac charts microsoft-excel-2011. I have got a table in excel in which one row is of months and another of monthly rent. Month Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Rent 234 345 324 123 432 122 I want the above two rows to be shown under the horizontal axis of the graph in excel.
Click the radio button next to 'Size With Chart.' Click 'Close' to close the window, and you will now just see your new text on the chart.
![Mac Mac](/uploads/1/2/5/4/125469045/209677464.png)
Learn how to use Excel for Mac 2011 to create different kinds of charts—from column, bar, and line charts to Gantt and exploded pie charts—and understand how to decide which type works best for your data. Plus, find out how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. Author Dennis Taylor also introduces analytical tools that will help you make sense of your data and a few dynamic controls that allow you to adapt your charts on the fly. Along the way, he provides tips and tricks to be more productive and efficient. Instructor.
Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training. Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator.
Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado. By: Dennis Taylor course.
4h 31m 16s. 1,422 viewers. Course Transcript - Voiceover Hi, I'm Dennis Taylor, and welcome to Excel for the Mac 2011: Charts in Depth.
Creating charts is one of Excel's most powerful, yet easy to use features. In this course, we'll be looking at the concepts underlying charts, and the tools to implement those concepts. I'll show you how to create standard and useful charts, and then how to fine tune those charts with a variety of techniques. We'll see how to add greater impact to your charts with pictures and shapes, and then examine the most effective use of titles, labels, legends, axes, and grid lines. We'll look at analytical tools that will help you make sense of chart data, and show you how to create dynamic charts that reflect fast changing business environments, and we'll give you a ton of shortcuts and tips that will make your use of this popular tool more efficient and productive. So, join me in Excel for the Mac 2011: Charts in Depth.
Practice while you learn with exercise files. Watch this course anytime, anywhere.
Course Contents. Introduction Introduction. 1. Creating Basic Charts Quickly 1. Creating Basic Charts Quickly. 2. Understanding Excel Chart Concepts 2.
Understanding Excel Chart Concepts. 3. Creating and Adjusting Chart Appearances with Charts Tab Choices 3. Creating and Adjusting Chart Appearances with Charts Tab Choices. 4. Using Chart Layout Tab Options 4.
Using Chart Layout Tab Options. 5. Using Format Tab Options and Other Visual Features 5. Using Format Tab Options and Other Visual Features. 6.
Customizing Specific Chart Types 6. Customizing Specific Chart Types. 7.
Changing a Chart's Data Source 7. Changing a Chart's Data Source. 8. Specialized Excel Charts 8. Specialized Excel Charts.
![For For](https://erc.barnard.edu/sites/default/files/styles/wysiwyg_largest/public/screen_shot_2013-10-24_at_12.55.35_pm.png?itok=NjUw6J5j)
9. Printing and Sharing Charts 9. Printing and Sharing Charts. 10.
In-Cell Chart Alternatives 10. In-Cell Chart Alternatives. 11. Chart Manipulation Tools 11.
Chart Manipulation Tools. Conclusion Conclusion.