Bar chart with a line next to the data in Excel

How to create a chart from Excel data

If you're creating charts that will require periodic updates, you can save time by creating the charts directly from your Excel data (Windows version of Mekko Graphics only).

Step 1: Select the range of your data in Excel and choose Chart in PowerPoint and then your chart type from the Mekko Graphics ribbon.

Chart from Excel 1

Step 2:

Open your PowerPoint file and select the slide where you would like to place the chart. Your cursor will be shown as a pointer with a chart. Click on the slide area to insert your chart.

Step 3:

Format the chart series. In this case, I want Net Margin to be shown only as a data row and EPS to be shown as a line plotted on the 2Y axis. I can make all of these selections using Bars and Series in the Mekko Graphics ribbon.

Apple Chart Format Bars and Series

Step 4:

You will be notified when the data in your Excel spreadsheet differs from what is shown in your chart. When you click on the chart and the border is green, your chart is in synch with the data. When the border is red, your chart is out of synch with the Excel data. To refresh the chart with new data, click on Link to Excel in the Mekko Graphics ribbon and select Refresh.

Apple Chart out of Synch

You can also create this chart directly in your Excel worksheet by choosing Chart in Excel in the Mekko Graphics ribbon. This can be helpful if you want to keep the charts with your Excel analysis or if you want to use Excel as a scratchpad for your chart while you're working on the analysis.

Apple Chart in Excel

Learn more about creating charts in Excel by checking out these posts.

10 Excel Tips You Should Know

How to Create a Marimekko Chart in Excel

How do I replicate an Excel chart but change the data?

Here's a video that shows you more ways to use Mekko Graphics with Excel, including:

  • Creating a marimekko chart from a pivot table
  • Linking an exisitng PowerPoint chart to Excel data
  • Building a monthly reporting package with charts in Excel