A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

mix chart types



 
 
Thread Tools Display Modes
  #1  
Old December 27th, 2005, 05:03 PM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

In Powerpoint I need to create a chart with multiple chart types. I want the
total to show up as a bar and the regions to be data points in the bar. Is
this possible?
  #2  
Old December 27th, 2005, 06:45 PM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

A combination chart uses two or more chart types to emphasize that the chart
contains different kinds of information. To create this kind of overlay
effect, change the chart type for one or more of the data series in the chart.

For most 2-D charts, you can change the chart type of either a data series
or the entire chart. For xy (scatter) and bubble charts, you can change only
the type of the entire chart. For most 3-D charts, changing the chart type
affects the entire chart. For 3-D bar and column charts, you can change a
data series to the cone, cylinder, or pyramid chart type.

Do one of the following:
To change the chart type of the entire chart, click the chart.

To change the chart type of a data series, click the data series.

On the Chart menu, click Chart Type.

On the Standard Types or Custom Types tab, click the chart type you want.
To apply the cone, cylinder, or pyramid chart type to a 3-D bar or column
data series, click Cylinder, Cone, or Pyramid in the Chart type box on the
Standard Types tab, and then select the Apply to selection check box.

If you clear the Apply to selection check box, Microsoft Graph changes the
chart type for the entire chart even if a single data series is selected.

Secondary axis... When the range of values for different data series
varies widely, or when you have mixed types of data, you can plot one or more
data series on a secondary value (y) axis. The scale of the secondary axis
reflects the values for the associated series. The chart in the example above
shows the number of homes sold on the left y-axis and the average price on
the right y-axis.

When the range of values for different data series in a 2-D chart varies
widely, or when you have mixed types of data (such as price and volume), you
can plot one or more data series on a secondary value (y) axis. The scale of
the secondary axis reflects the values for the associated series.

Click the data series you want to plot along a secondary value axis.

On the Format menu, click Selected Data Series, and then click the Axis tab.

Click Secondary axis.

Hope this info helps!!!
--
John Fallon
Instructional Technology Evangelist for PPT4Teachers.com
Where Instruction and Technology meet for Teachers and the Classroom
http://www.ppt4teachers.com


"Ken Murray" wrote:

In Powerpoint I need to create a chart with multiple chart types. I want the
total to show up as a bar and the regions to be data points in the bar. Is
this possible?

  #3  
Old April 27th, 2006, 10:05 AM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

The "Apply to selection" check box is not enabled in the chart type options
in Microsoft Graph. How do I enable it? I tried using other computers with
2003 installed but they are all disabled.


"Ken Murray" wrote:

In Powerpoint I need to create a chart with multiple chart types. I want the
total to show up as a bar and the regions to be data points in the bar. Is
this possible?

  #4  
Old April 27th, 2006, 10:26 AM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

Hi,

Did you have one of the data series selected when you displayed the
dialog. It will be disabled if you have just the chart or plot area
selected.

Cheers
Andy

Chris Vistro wrote:
The "Apply to selection" check box is not enabled in the chart type options
in Microsoft Graph. How do I enable it? I tried using other computers with
2003 installed but they are all disabled.


"Ken Murray" wrote:


In Powerpoint I need to create a chart with multiple chart types. I want the
total to show up as a bar and the regions to be data points in the bar. Is
this possible?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #5  
Old April 27th, 2006, 10:35 AM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

Hi,
Yes. I selected the data series that I wanted to change the chart type of.
But when I go to Chart - Chart Type, the selection option is still disabled.


"Chris Vistro" wrote:

The "Apply to selection" check box is not enabled in the chart type options
in Microsoft Graph. How do I enable it? I tried using other computers with
2003 installed but they are all disabled.


"Ken Murray" wrote:

In Powerpoint I need to create a chart with multiple chart types. I want the
total to show up as a bar and the regions to be data points in the bar. Is
this possible?

  #6  
Old April 27th, 2006, 02:21 PM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

What type is the chart now, and what type are you trying to apply to the
selected data series?

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


"Chris Vistro" wrote in message
...
Hi,
Yes. I selected the data series that I wanted to change the chart type of.
But when I go to Chart - Chart Type, the selection option is still
disabled.


"Chris Vistro" wrote:

The "Apply to selection" check box is not enabled in the chart type
options
in Microsoft Graph. How do I enable it? I tried using other computers
with
2003 installed but they are all disabled.


"Ken Murray" wrote:

In Powerpoint I need to create a chart with multiple chart types. I
want the
total to show up as a bar and the regions to be data points in the bar.
Is
this possible?



  #7  
Old April 28th, 2006, 01:21 AM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

The chart is now in Column type. I want to apply the Area type to the
selected data series while maintaining the rest of the chart in Column type.


"Echo S" wrote:

What type is the chart now, and what type are you trying to apply to the
selected data series?

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


"Chris Vistro" wrote in message
...
Hi,
Yes. I selected the data series that I wanted to change the chart type of.
But when I go to Chart - Chart Type, the selection option is still
disabled.


"Chris Vistro" wrote:

The "Apply to selection" check box is not enabled in the chart type
options
in Microsoft Graph. How do I enable it? I tried using other computers
with
2003 installed but they are all disabled.


"Ken Murray" wrote:

In Powerpoint I need to create a chart with multiple chart types. I
want the
total to show up as a bar and the regions to be data points in the bar.
Is
this possible?




  #8  
Old April 28th, 2006, 02:50 AM posted to microsoft.public.powerpoint
external usenet poster
 
Posts: n/a
Default mix chart types

Seems to work here.

Try just right-clicking a data series and choosing Chart Type. Oh, and
you'll want to be working with a 2D column chart, not a 3D one.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


"Chris Vistro" wrote in message
...
The chart is now in Column type. I want to apply the Area type to the
selected data series while maintaining the rest of the chart in Column
type.


"Echo S" wrote:

What type is the chart now, and what type are you trying to apply to the
selected data series?

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


"Chris Vistro" wrote in message
...
Hi,
Yes. I selected the data series that I wanted to change the chart type
of.
But when I go to Chart - Chart Type, the selection option is still
disabled.


"Chris Vistro" wrote:

The "Apply to selection" check box is not enabled in the chart type
options
in Microsoft Graph. How do I enable it? I tried using other computers
with
2003 installed but they are all disabled.


"Ken Murray" wrote:

In Powerpoint I need to create a chart with multiple chart types. I
want the
total to show up as a bar and the regions to be data points in the
bar.
Is
this possible?






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I share User-Defined Custom Chart Types in Pivot Charts? jantz_question Charts and Charting 0 September 20th, 2005 01:39 PM
Multiple filter query of form truepantera Using Forms 6 August 4th, 2005 08:26 AM
Mixing chart types E Halliday Charts and Charting 2 May 16th, 2005 01:43 PM
Adding new series to chart with two series types Bill Charts and Charting 1 November 14th, 2004 07:43 PM
Chart Types MELL Charts and Charting 1 February 20th, 2004 08:56 AM


All times are GMT +1. The time now is 09:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.