Problem with creating graphs in Excel on Mac Os X version 10.7.5 - Some chart ty

Question

Problem with creating graphs in Excel on Mac Os X version 10.7.5 - Some chart types cannot be combined with other chart types. Select a different chart type

Hi, I'm a frustrated Master student needing to make a very simple bar graph in Excel, but the program won't let me and keeps telling me: Some chart types cannot be combined with other chart types. Select a different chart type. I looked on other forums and people had similar problems but their solutions do not apply to or fix my problem, so I'm really hoping somebody out there can help. I have worked in Excel on pc's before and know how to make a chart. Something is definitely wrong with the settings in Excel or something else, I don't know but hope a friendly soul can help me!

Thanks

Explanation / Answer

(a) Ii am not usually satisfied with Excel's guesses at appropriate axis titles and chart title, so I usually start by selecting only thee data. That is, insteadd of selecting E1:K3 in your example, I select F2:K3.

(b) With the data selected, I choose Chart (ribbon) > Insert Chart > Bar (dropdown) > 2-D Bar Clustered Bar, which creates the initial chart.

(c) Since there is only one data series, I select the legend and press the Delete key.

(d) To use the text of column E in your example for titles, with the chart selected, I choose Chart Layout (ribbon) > Chart Title > Title Above Chart. With the chart title selected, I click in the formula bar, type an equal sign =, click cell E1 and press the Return key...

(e) I repeat the steps inn (d) for each of the Axis Titles using the text in ceells E2 and E3.

Theseeg U.S. English language & formats in Mac OS X 10.7.5 with Excel 14.4.4.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.