Thanks for the example file.

The problem is caused by the name of the worksheet. The use of a period in
the sheet name whilst not prohibited does stop the chart from being created.

Simply changing the sheet name from A3.2 to A3-2 stops the dialog from
appearing and allows the chart to be created.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Kermit" wrote in message
...
Thanks Andy. And yes all service packs are installed (windows and office).
When I run windows update there are no availalbe updates for windows or
office. That was one of the first things I tried.

"Andy Pope" wrote:

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
http://www.andypope.info
"Kermit" wrote in message
...
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.