Excel automatically inserts a legend with default formatting at your selected location in the chart. You can then format the legend's font and change its location via the Legend Options Information in this article applies to Excel 2011 for Mac. It may vary slightly or significantly with other versions or products. ![]() Related Tips •: To present average line or a target you can insert a horizontal line in a chart and here are the [.] •: To make best out of Excel chart the best way is to make them interactive and these are the simple and easy [.] •: Updating a chart again and again is not a good idea but you create a dynamic range by using [.] •: One the best thing you can do with you charts is using a dynamic chart title and in this post [.] •: Want to save time while formatting chart? All you need is quick tip to copy and past chart formatting [.] •: A quick tip make your favorite chart as the default chart which you can insert with a shortcut key [.]. I want to draw a simple combo chart which is easy with the Windows version in Excel. We have a goal of 95% and achievements as follows: 2009 73% 2010 61% 2011 82% 2012 82% It shouldn't be this hard to have a column chart for each year's achievement, and a line for the goal. Please help if you can. -------------Problems Reply------------ A combination chart (in either WinXL or MacXL) has at least two series. You show only one. You could add another series with a constant value of 95% for each year. Make your column chart with both series, right-click one of the constant data points and choose Change Series Chart Type and make the series a line. Alternatively, you could just as easily skip the second series and choose Insert/Shape to draw a line at 95%. Group the line and the Chart so that they move together. Thank you for taking the time to reply to my question, Mr. Unfortunately, I can't even get the Mac Excel to create a chart the single series I indicated. Instead, it gives me the following: I think that I made a mistake buying the Mac version of Excel. ![]() I use Parallels with my Mac, I have a WIndows computer as well. I might as well buy the WIndows version of this program and install it. It's amazing that Microsoft made such a poor imitation of a terrific program to use with the Mac. Again, thanks for your effort. Bob Grossman Sorry about that! I tried to cut and paste the inserted chart into my reply and it failed. The chart I produced when I clicked Insert Chart was nothing more than a model showing two series, one at zero and the other at 2000. In other words it didn't even reference the correct date series. Again, thanks for trying! Without knowing what your data looks like, it's almost impossible to suggest anything - it's absolutely no harder to create a chart in MacXL than it is in WinXL. In most cases just selecting your data source (or even a single cell in your data source) and clicking a chart type in Charts section of the XL2008 Elements Gallery, (or the the Charts tab of the XL2011 ribbon). I'm sorry I wasn't more explicit in my question. Here's the data: 2009 73% 2010 61% 2011 82% 2012 82% Goal 95% When I do what you suggest, i.e., highlight the data and click a chart type, all I get is a MODEL CHART, one that doesn't relate to the selected data. In the 2003 version of Excel, that's all I had to do and a chart appeared. I could also easily change the chart type for a single part of the data, e.g., the goal, and produce a combination chart. So my question is what am I doing wrong? Thanks in advance for your help. Mac proxy for email address. Open the program and click 'Tools.' Select 'E-Mail Accounts' and click 'View or Change Existing E-Mail Accounts Options.' Click 'Next.' Highlight the e-mail account types that have already been configured. Click 'Change.' This brings up the 'Internet E-Mail Settings' dialog box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |