Problem with creating graphs inn Excel on Mac Os X version 10.7.5 - Some chart t

Question

Problem with creating graphs inn Excel on Mac Os X version 10.7.5 - Some chart types cannot be combined with other chart types. Select a different chaart 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 realyy hoping someebody out there ccan help. I have worked in Excel on pc's before and know how to make a chart. Something is deefinitely 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) I am not usually satisfied with Excel's guesses at appropriate axis titles and chart title, so I usually start by selecting only the 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 exxample 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 keey.

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

These steps work fine for me using 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.