Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default error message "Some chart types cannot be combined with other char

I am getting this error message "Some chart types cannot be combined with
other chart types. Select a different chart type"

with the same selection sometimes it goes smoothly, and sometimes i get this
message, and i am only trying to do a very basic column shart with the names
of the counties and the number of accidents for 5 years for each county

what am i doing wrong?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: error message "Some chart types cannot be combined with other char

This error message usually occurs when you are trying to combine two or more chart types that are not compatible with each other. For example, you cannot combine a column chart with a pie chart or a line chart with a scatter chart.

To resolve this issue, you need to make sure that you are selecting compatible chart types. In your case, since you are trying to create a basic column chart with the names of the counties and the number of accidents for 5 years for each county, you should select only the column chart type.

Here are the steps to create a basic column chart in Microsoft Excel:
  1. Select the data range that you want to include in the chart.
  2. Click on the "Insert" tab in the ribbon.
  3. Click on the "Column" chart type in the "Charts" group.
  4. Select the specific column chart subtype that you want to use.
  5. The chart will be inserted into your worksheet.

If you are still experiencing issues, you may want to check if your data is formatted correctly. Make sure that your data is organized in columns or rows and that there are no blank cells or extra spaces. Also, ensure that the data is in a numerical format and not in text format.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default error message "Some chart types cannot be combined with otherchar

Hi,

I have not heard of that warning happening sporadically. It only happens
when you try to combine charts that will not mix.
When you say it sometimes works is that when trying the same mixture on
the same chart or another chart that looks similar?

Cheers
Andy

n_alexiou wrote:
I am getting this error message "Some chart types cannot be combined with
other chart types. Select a different chart type"

with the same selection sometimes it goes smoothly, and sometimes i get this
message, and i am only trying to do a very basic column shart with the names
of the counties and the number of accidents for 5 years for each county

what am i doing wrong?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default error message "Some chart types cannot be combined with other

I am also getting the same message. I am trying to create a scatter graph
using a) draft selection and b)what score they got. I have 9 tables created
1997-2005 with the same info in all of them. The graph creates 97-04 but when
i add 2005 to the information then the warning comes up. Why does it work
with 8 years of info but not with 9?

"Andy Pope" wrote:

Hi,

I have not heard of that warning happening sporadically. It only happens
when you try to combine charts that will not mix.
When you say it sometimes works is that when trying the same mixture on
the same chart or another chart that looks similar?

Cheers
Andy

n_alexiou wrote:
I am getting this error message "Some chart types cannot be combined with
other chart types. Select a different chart type"

with the same selection sometimes it goes smoothly, and sometimes i get this
message, and i am only trying to do a very basic column shart with the names
of the counties and the number of accidents for 5 years for each county

what am i doing wrong?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default error message "Some chart types cannot be combined with other

Hi,

If you want to email me the file, off newsgroup, I will have a look at
what maybe causing this.

andy AT andypope DOT info

Cheers
Andy

SHERO wrote:
I am also getting the same message. I am trying to create a scatter graph
using a) draft selection and b)what score they got. I have 9 tables created
1997-2005 with the same info in all of them. The graph creates 97-04 but when
i add 2005 to the information then the warning comes up. Why does it work
with 8 years of info but not with 9?

"Andy Pope" wrote:


Hi,

I have not heard of that warning happening sporadically. It only happens
when you try to combine charts that will not mix.
When you say it sometimes works is that when trying the same mixture on
the same chart or another chart that looks similar?

Cheers
Andy

n_alexiou wrote:

I am getting this error message "Some chart types cannot be combined with
other chart types. Select a different chart type"

with the same selection sometimes it goes smoothly, and sometimes i get this
message, and i am only trying to do a very basic column shart with the names
of the counties and the number of accidents for 5 years for each county

what am i doing wrong?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default error message "Some chart types cannot be combined with other

Hi,
I also get the same message event with a simple data. This only happen with
excel 2007. I have try the same file with Excel 2003 and it OK.

"Andy Pope" wrote:

Hi,

If you want to email me the file, off newsgroup, I will have a look at
what maybe causing this.

andy AT andypope DOT info

Cheers
Andy

SHERO wrote:
I am also getting the same message. I am trying to create a scatter graph
using a) draft selection and b)what score they got. I have 9 tables created
1997-2005 with the same info in all of them. The graph creates 97-04 but when
i add 2005 to the information then the warning comes up. Why does it work
with 8 years of info but not with 9?

"Andy Pope" wrote:


Hi,

I have not heard of that warning happening sporadically. It only happens
when you try to combine charts that will not mix.
When you say it sometimes works is that when trying the same mixture on
the same chart or another chart that looks similar?

Cheers
Andy

n_alexiou wrote:

I am getting this error message "Some chart types cannot be combined with
other chart types. Select a different chart type"

with the same selection sometimes it goes smoothly, and sometimes i get this
message, and i am only trying to do a very basic column shart with the names
of the counties and the number of accidents for 5 years for each county

what am i doing wrong?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default error message "Some chart types cannot be combined with other

Excel 2007 is less flexible when combining different chart types. For
example, in Excel 2003 you could add a line or XY series to a stock
chart. Excel 2007 doesn't let you add any type to a stock chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Afzal wrote:
Hi,
I also get the same message event with a simple data. This only happen with
excel 2007. I have try the same file with Excel 2003 and it OK.

"Andy Pope" wrote:

Hi,

If you want to email me the file, off newsgroup, I will have a look at
what maybe causing this.

andy AT andypope DOT info

Cheers
Andy

SHERO wrote:
I am also getting the same message. I am trying to create a scatter graph
using a) draft selection and b)what score they got. I have 9 tables created
1997-2005 with the same info in all of them. The graph creates 97-04 but when
i add 2005 to the information then the warning comes up. Why does it work
with 8 years of info but not with 9?

"Andy Pope" wrote:


Hi,

I have not heard of that warning happening sporadically. It only happens
when you try to combine charts that will not mix.
When you say it sometimes works is that when trying the same mixture on
the same chart or another chart that looks similar?

Cheers
Andy

n_alexiou wrote:

I am getting this error message "Some chart types cannot be combined with
other chart types. Select a different chart type"

with the same selection sometimes it goes smoothly, and sometimes i get this
message, and i am only trying to do a very basic column shart with the names
of the counties and the number of accidents for 5 years for each county

what am i doing wrong?
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Charts and Charting in Excel 15 June 2nd 09 10:53 AM
MSN stock quotes - Error message "problem displaying attributes" jd Excel Discussion (Misc queries) 0 November 13th 07 10:34 PM
"Unable to Read File" error message in Excel - solutions? Presby Loaner Excel Discussion (Misc queries) 2 June 27th 07 05:09 PM
Deleted the pivot table - continue to get the "overlap" error message [email protected] Excel Discussion (Misc queries) 0 September 27th 06 04:07 PM
excel 2003 "french "always reloads with error message when closin didid68 Excel Discussion (Misc queries) 0 March 3rd 06 07:58 AM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"