Thans for your response Luke,

I think you misunderstood me. 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. 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".

I would be happy to email the file in question to someone who thinks they
can help.