Excel line graph tutorial mac

Click on the series that you want to change to a different type, so that the series is highlighted. Click the Change Chart Type button and pick a new chart type. The new type will only be applied to the selected series, so you end up with whatever combination you want. We will take this feedback into consideration and perhaps make combo charts easier to discover.

Totally agree. Interestingly, I created a two axis chart in Excel for Windows then opened in Excel for Mac both and now several menu items are available! For instance, in creating it in Mac the "Add Chart Element" only showed primary axis as an option. But after opening the Windows spreadsheet, now the Mac version shows both the Primary and Secondary axis as a menu option. So there is a lot of functionality on the Mac version that just is not exposed to the native interface.

How to make a line graph in Excel

This cannot be a major thing to simply expose menu items and controls that already exist in the Mac version. We've just sent you an email to. Click the link to create a password, then come back here and sign in. We are now required to have consent to store personal data.

Since you already have data stored on this site, please select one of the following:. Please note that if you do not select an option, we will be required to delete your feedback profile and personal information. All of your personal information, including email address, name, and IP address will be deleted from this site. Both work equally well. You can include as many different lines in a line chart as you want , but we recommend keeping it to a handful at most. If you forget which button to click, just hover over the options. Excel will tell you which one is which. Mouse over them to see a preview:.

Clicking any of these styles will immediately format your chart.

How to Add a Legend on Excel for Mac | It Still Works

Different styles include a variety of chart elements. Excel automatically calculates the standard error or whatever is necessary for your chosen element and inserts it into the graph. Data tables, grid lines, trend lines, axis labels, and more can be found in this menu. It should be your first stop when editing a line graph. Select any color combination and your line chart will get a quick makeover:. Markers are the symbols often circles at each point on your line. Then select the type and size. The resulting window will let you type or click-and-drag to select the data that should be included in your graph.

Organize your data so that each category has all the corresponding values in the same row or column :. But it can be a very powerful tool for presenting data! One last step: just let us know where should we should send it.

Download The Excel Doc

Unlike Excel, Pages won't allow you to export your chart as an image. So, if you want to use your graph in another piece of software Word, for example then the best way to do this is to take a screenshot of it and insert it in as a PNG file. I hope that it has given you a good overview of how to create some awesome-looking charts in Pages and that after reading it, you'll let your imagination run wild!

Charts are a really good way of presenting information and remember that this guide is only the beginning -- you can do a lot more besides creating simple bar graphs like we've seen above!

Dashboard Series: Creating Combination Charts In Excel

Please let us know what you think of this tutorial in the Comments section, below, and if you need any help or explanation of anything covered, then please ask! I'll try and get back to you as soon as possible.


  • How to Make and Format a Line Graph in Excel.
  • How to Create Combination Charts in Excel - Step-by-Step Tutorial.
  • Dynamic Charts in Excel 2016 for Mac?
  • Make a PowerPoint timeline from Excel;
  • g++ compiler for mac terminal?

Save Now. Subscribe Sign In. Web Design. Game Development. Computer Skills.

Excel 2008: Create a Chart or Graph

Learning Guides. Computer Skills Productivity. How to Create Awesome Charts in Pages. Productivity OS X Pages. Getting Started Go ahead and load up Pages then click on New Document in the bottom left-hand corner.

Pages allows you to create all sorts of charts, from bar to scatter graphs. Placing Your Chart For starters, I'm going to create a bar chart for some sample sales data for two different products across a few years. The options available to you when creating a chart in Pages. Working With Data When it comes to charts, there are two ways of working with data.

The data editor within Pages.


  • How to Create a Line Chart in Excel | irylidypig.tk.
  • ubuntu live usb mac efi;
  • Never miss a post..
  • Dashboard Series: Creating Combination Charts In Excel.
  • business card maker for mac free.
  • MS Excel How to Create a Line Chart.
  • konica minolta c280 driver download mac.

Deleting a column within the data editor. The finished product!

Now that we've got our data in our chart, it's time to start playing around with it! Customising Your Chart Just liked I mentioned in my previous tutorials, when it comes to customising anything within the iWork suite then the Inspector view is your friend. The Inspector allows you to customise your graph to exactly how you want it. Adding a title to your chart. Changing the colour of your chart. Playing With the Axes Pages automatically selects axes that fit your data the best, but depending on your data this may give you some odd results as you can see in the examples above, the steps are 0, Customising the axes within the Inspector.

As you can see, I've now got 6 steps in my chart instead of 4, which looks a lot neater. Some more advanced options for your axes. Other Stuff Clicking on the Series tab brings up a couple of more options that allow you to customise your graph further.