Once your actual data and dummy data have the same number of rows and columns, copy the actual data from your Excel sheet and paste to overwrite the dummy data, as shown within the results in Figure 5, below.
#Print chart on excel 2011 for mac series
This is again explained within our Adding and Deleting Chart Series and Categories tutorial. Conversely, if your Excel data includes fewer series or categories, you will need to delete that many rows/columns from the dummy data.Here, Wall Street Prep has compiled the most important time-saving Excel shortcuts for both Windows and Mac. Quite simply, it’s well worth the time to learn them. We added one extra row and one extra column, as shown in Figure 4.įigure 4: Chart categories and series added Excel shortcuts are a fundamental component of efficient financial modeling.
#Print chart on excel 2011 for mac for mac
Thereafter, make sure that the Excel sheet containing the chart's dummy data is visible, as shown in Figure 2, previously on this page.
Want to bring up this Excel sheet that contains data after your chart has already been created? Explore our Edit Chart Data in PowerPoint 2011 for Mac tutorial.