combination chart excel for mac change line to bar

To use the Excel tools in Office 2011 for Mac, be sure to click the charts border to select the chart before applying the tool.

Youll want the chart type that displays your data in the most effective visual format.

On the Ribbons Charts tab, find the Change Chart Type group and try various chart types by clicking the buttons.

The next stop is the Chart Quick Layouts gallery on the Ribbon.

Click the scroll buttons at each end of the gallery, or click the sweet spot at the middle of the bottom border to display a drop-down gallery.

Some layouts include chart titles and other data labels, which are text boxes you can type in to customize your chart.

The Chart Styles gallery on the Ribbon has intriguing and beautiful styles based on the theme applied to your workbook.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

It shows the tally sold and money earned over 4 months, comparing members and non-member sales.

The chart looks great except for one annoying thing: the line chart on the y-axis (showing the tallies sold) does not line up to the bar chart on the x-axis (showing member or non-member money earned).

Its smack bang in the middle of both of them according to the month.

How do I get the line chart (y-axis) to match up with the bar char (x-axis) Ive searched many forums to try and find an answer, but it has been most illusive.

And it is lining up with the x axis - assuming Ive understood your data.

Unlike columns which have width the line is made up of single points.

So, the yellow line moved 1cm to the right and the red line 1cm to the left.

And you will also need to provide the x values best suited to you chart.

On the rare occasions when I do this, I find that having the secondary x axis displayed makes it easier to see what values I need to choose for the x values.

Combination Chart Excel For Mac Change Line To Bar