Adding the Mean. To add the mean as a series of markers, select the Mean row in the calculated range (highlighted in blue). If you are making a horizontal box plot, hold Ctrl and also select the Offset row (highlighted in green), so both areas are selected. 2011 (Mac): With the Conversion Rate series selected, choose Charts tab > Change Series Chart Type > Line > 2-D Line > Line. Then select the series again like you did before (it doesn’t stay.

I am receiving the error 'Some chart types cannot be combined with other chart types. Select a different chart type.' Funny thing is.

This is the only chart I am trying to create. There are no other charts in the entire workbook. Moving the data to another sheet in the workbook does not work. I am running excel 07. I can copy the data to a new workbook and create the chart with no problem. Is it possible that something in this specific workbook is corrupted?

If I copy the chart from the new workbook to the bad one, all the data 'disappears'. I would be happy to email the file in question to someone who thinks they can help. That error message does not have anything to do with multiple charts/moving charts. Its telling you that you can' combine chart types. I.e., you can't make a chart with 1 series being a chart, and the other being a line chart. Commonly used combination charts are column-line, scatter-column. Hope this gives you a better idea of what's going wrong.

-- Best Regards, Luke M *Remember to click 'yes' if this post helped you!* 'Kermit' wrote: I am receiving the error 'Some chart types cannot be combined with other chart types. Select a different chart type.'

Funny thing is. This is the only chart I am trying to create. There are no other charts in the entire workbook. Moving the data to another sheet in the workbook does not work. I am running excel 07.

I can copy the data to a new workbook and create the chart with no problem. Is it possible that something in this specific workbook is corrupted? If I copy the chart from the new workbook to the bad one, all the data 'disappears'. I would be happy to email the file in question to someone who thinks they can help.

Thans for your response Luke, I think you misunderstood me. Best computer for 3d rendering 2015 mac. I am not trying to combine chart types. I have a column of 7 numbers that I want to make into a column chart. I do not want any other chart type at all. Excel will not let me create a chart at all. If I highlight my 7 numbers, then click insert, and then any type of chart at all, I get the error message. If I copy the data into a new workbook (copy, paste special, paste values), it works fine.

• 5.3 Feb 27, 2017. Christine Jake and Logan, Use it all of the time. Get a crisp collage output now.

If I copy or move the worksheet to a new workbook, I get the same error. That's what leads me to believe that this one workbook is corrupted somehow. I would prefer not to have to create this workbook from scratch again, and while having two workbooks (one for data and one for charts) is a solution, I don't think I should have to do that. 'Luke M' wrote: That error message does not have anything to do with multiple charts/moving charts. Its telling you that you can' combine chart types. I.e., you can't make a chart with 1 series being a chart, and the other being a line chart. Commonly used combination charts are column-line, scatter-column.

Hope this gives you a better idea of what's going wrong. -- Best Regards, Luke M *Remember to click 'yes' if this post helped you!* 'Kermit' wrote: I am receiving the error 'Some chart types cannot be combined with other chart types. Select a different chart type.' Funny thing is. This is the only chart I am trying to create.

There are no other charts in the entire workbook. Moving the data to another sheet in the workbook does not work. I am running excel 07. I can copy the data to a new workbook and create the chart with no problem. Is it possible that something in this specific workbook is corrupted? If I copy the chart from the new workbook to the bad one, all the data 'disappears'.

So you have to manually select it. For this, go to the software installation location and select the amtlib.dll file and click Open to enable the software. 4) You will be warned that the file was not found.

I would be happy to email the file in question to someone who thinks they can help. Hi, If you want to email me the workbook I will take a look and see if I can discover why, other than corruption, you get the message. Andy AT andypope DOT info Do you have the service pack installed? Cheers Andy -- Andy Pope, Microsoft MVP - Excel 'Kermit' wrote in message.