Graph - axis switching for a line graph

[Guest]

I have to create a combo bar/line graph. I need the X-axis for both to run
down vertically (like a typical bar graph). However, I cannot seem to force
the line to run down vertically, it wants to stay on a horizontal axis (makes
two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002

 

[Echo S]

Try switching to Data by Column instead of Data by Row or vice versa. (Those
options are on one of the menus when you have the chart activated.)

 

[Guest]

Uh, no. I don't have a problem with the datasheet - all my data shows up on
the graph correctly, I can't force PPT to display it the way I want it.
Maybe this will help:
- Create a 2-series graph (dummy data, whatever)
- Change chart type to a simple clustered bar chart (not column)
- Select the 2nd series and change it's chart type to a line chart
Notice how the line takes itself off of the original y-axis and creates a
new secondary axis for it to use. Or think about it this way, if you create
this graph as a simple clustered column chart with the second series as a
line, then rotate the whole graph 90 degrees, that's what I need.

Make more sense? Thanks!!

Try switching to Data by Column instead of Data by Row or vice versa. (Those
options are on one of the menus when you have the chart activated.)

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I have to create a combo bar/line graph. I need the X-axis for both to run
down vertically (like a typical bar graph). However, I cannot seem to force
the line to run down vertically, it wants to stay on a horizontal axis (makes
two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002

 

[Echo S]

Boy, I sure didn't get that from the first description!

Off the top of my head, I don't know how you can get that configuration
without creating two separate graphs -- or creating one and rotating it.
(You'd of course have to Paste Special as WMF and ungroup to rotate the
text. Or rotate the text in the graph first.

Wonder if this could be done in Excel?

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Uh, no. I don't have a problem with the datasheet - all my data
shows up on the graph correctly, I can't force PPT to display it the
way I want it. Maybe this will help:
- Create a 2-series graph (dummy data, whatever)
- Change chart type to a simple clustered bar chart (not column)
- Select the 2nd series and change it's chart type to a line chart
Notice how the line takes itself off of the original y-axis and
creates a new secondary axis for it to use. Or think about it this
way, if you create this graph as a simple clustered column chart with
the second series as a line, then rotate the whole graph 90 degrees,
that's what I need.

Make more sense? Thanks!!

Try switching to Data by Column instead of Data by Row or vice
versa. (Those options are on one of the menus when you have the
chart activated.)

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I have to create a combo bar/line graph. I need the X-axis for
both to run down vertically (like a typical bar graph). However, I
cannot seem to force the line to run down vertically, it wants to
stay on a horizontal axis (makes two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002

 

[Guest]

You know, sometimes I think I'm describing the color of a fruit but other
people think I'm talking about the speed of a plane! ;-)
I already tried it in Excel, doesn't work there either. Any suggestions for
a work-around? (please!!)

Thanks for trying!

Boy, I sure didn't get that from the first description!

Off the top of my head, I don't know how you can get that configuration
without creating two separate graphs -- or creating one and rotating it.
(You'd of course have to Paste Special as WMF and ungroup to rotate the
text. Or rotate the text in the graph first.

Wonder if this could be done in Excel?

--
Echo [MS PPT MVP]
http://www.echosvoice.com

Uh, no. I don't have a problem with the datasheet - all my data
shows up on the graph correctly, I can't force PPT to display it the
way I want it. Maybe this will help:
- Create a 2-series graph (dummy data, whatever)
- Change chart type to a simple clustered bar chart (not column)
- Select the 2nd series and change it's chart type to a line chart
Notice how the line takes itself off of the original y-axis and
creates a new secondary axis for it to use. Or think about it this
way, if you create this graph as a simple clustered column chart with
the second series as a line, then rotate the whole graph 90 degrees,
that's what I need.

Make more sense? Thanks!!

Try switching to Data by Column instead of Data by Row or vice
versa. (Those options are on one of the menus when you have the
chart activated.)

--
Echo [MS PPT MVP]
http://www.echosvoice.com


I have to create a combo bar/line graph. I need the X-axis for
both to run down vertically (like a typical bar graph). However, I
cannot seem to force the line to run down vertically, it wants to
stay on a horizontal axis (makes two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002

 

[Andy Pope]

Hi,

Ideally you would plot the dots as an xy scatter rather than a line but
MSGraph will not allow you to combine the two chart types.

As Echo suggests maybe use Excel, which will allow the combination.

For a PPT work around you could plot two extra data series on the
secondary axis as stacked bar. The first bar is used for padding. The
second bar has a custom fill to match required marker. You will need to
play around with the value for this to give the correct appearence for
your marker. The value of the pad bar will also have to be calculated to
align the marker in the correct place.

I will assemble an example and post back with the link.

Cheers
Andy

Uh, no. I don't have a problem with the datasheet - all my data shows up on
the graph correctly, I can't force PPT to display it the way I want it.
Maybe this will help:
- Create a 2-series graph (dummy data, whatever)
- Change chart type to a simple clustered bar chart (not column)
- Select the 2nd series and change it's chart type to a line chart
Notice how the line takes itself off of the original y-axis and creates a
new secondary axis for it to use. Or think about it this way, if you create
this graph as a simple clustered column chart with the second series as a
line, then rotate the whole graph 90 degrees, that's what I need.

Make more sense? Thanks!!

:

Try switching to Data by Column instead of Data by Row or vice versa. (Those
options are on one of the menus when you have the chart activated.)

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I have to create a combo bar/line graph. I need the X-axis for both to
run

down vertically (like a typical bar graph). However, I cannot seem to
force

the line to run down vertically, it wants to stay on a horizontal axis
(makes

two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002

 

[Echo S]

You know, sometimes I think I'm describing the color of a fruit but
other people think I'm talking about the speed of a plane! ;-)
LOL!

I already tried it in Excel, doesn't work there either. Any
suggestions for a work-around? (please!!)

Sorry, no, the only thing I can think of is to rotate it. And since you
can't rotate a graph, you'll have to make an image and rotate that. Here's
what I'd do:

Create a column chart and set all the text alignment to 90 degrees. Then
copy the chart, right-click the original and choose Format Object, change to
5%x5% on the Size tab, and then drag that off the edge of the slide. That
way you have the data intact if you need to make changes.

Then Edit/Paste Special and choose WMF from the list. Then Draw/Rotate and
rotate 90 degrees right. Then Draw/Ungroup if you need to make mintor
changes or adjustments (do the ungroup twice since you're using PPT 2002).

That's the best I can do! :-(

A couple of Excel MVPs pop in here regularly. I'm sure if one of them knows
a way to do this in Excel, they'll post the info.

Thanks for trying!

You're welcome. I just wish I could come up with something better!

 

[Andy Pope]

Here you go. Hopefully a explanation you can understand.
http://www.andypope.info/ngs/ng43.htm

Cheers
Andy

Hi,

Ideally you would plot the dots as an xy scatter rather than a line but
MSGraph will not allow you to combine the two chart types.

As Echo suggests maybe use Excel, which will allow the combination.

For a PPT work around you could plot two extra data series on the
secondary axis as stacked bar. The first bar is used for padding. The
second bar has a custom fill to match required marker. You will need to
play around with the value for this to give the correct appearence for
your marker. The value of the pad bar will also have to be calculated to
align the marker in the correct place.

I will assemble an example and post back with the link.

Cheers
Andy

Uh, no. I don't have a problem with the datasheet - all my data shows
up on the graph correctly, I can't force PPT to display it the way I
want it. Maybe this will help:
- Create a 2-series graph (dummy data, whatever)
- Change chart type to a simple clustered bar chart (not column) -
Select the 2nd series and change it's chart type to a line chart
Notice how the line takes itself off of the original y-axis and
creates a new secondary axis for it to use. Or think about it this
way, if you create this graph as a simple clustered column chart with
the second series as a line, then rotate the whole graph 90 degrees,
that's what I need.

Make more sense? Thanks!!

:

Try switching to Data by Column instead of Data by Row or vice versa.
(Those
options are on one of the menus when you have the chart activated.)

--
Echo [MS PPT MVP]
http://www.echosvoice.com



I have to create a combo bar/line graph. I need the X-axis for both to


run

down vertically (like a typical bar graph). However, I cannot seem to


force

the line to run down vertically, it wants to stay on a horizontal axis


(makes

two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002

 

[Echo S]

Ahhhh. Dummy data. Got it. (Thinking rotating is probably easier in this
case, LOL!)

Thanks, Andy.

 

[Guest]

Wowzers! Now that is some workaround! I guess that where there's a will,
there's always a way. ;-)

That's a great idea, but since I'm only setting these up, and won't be the
one working on these, I'd better not make them to complicated. (can't
imagine trying to explain to a project person how to take their new data and
make this chart!)

Thanks very much for all your help! I will definitely keep this idea in
mind if I ever have to do one of these for myself - in a controlled
environment, namely mine, it'll work great.

Here you go. Hopefully a explanation you can understand.
http://www.andypope.info/ngs/ng43.htm

Cheers
Andy

Hi,

Ideally you would plot the dots as an xy scatter rather than a line but
MSGraph will not allow you to combine the two chart types.

As Echo suggests maybe use Excel, which will allow the combination.

For a PPT work around you could plot two extra data series on the
secondary axis as stacked bar. The first bar is used for padding. The
second bar has a custom fill to match required marker. You will need to
play around with the value for this to give the correct appearence for
your marker. The value of the pad bar will also have to be calculated to
align the marker in the correct place.

I will assemble an example and post back with the link.

Cheers
Andy

Uh, no. I don't have a problem with the datasheet - all my data shows
up on the graph correctly, I can't force PPT to display it the way I
want it. Maybe this will help:
- Create a 2-series graph (dummy data, whatever)
- Change chart type to a simple clustered bar chart (not column) -
Select the 2nd series and change it's chart type to a line chart
Notice how the line takes itself off of the original y-axis and
creates a new secondary axis for it to use. Or think about it this
way, if you create this graph as a simple clustered column chart with
the second series as a line, then rotate the whole graph 90 degrees,
that's what I need.

Make more sense? Thanks!!

:


Try switching to Data by Column instead of Data by Row or vice versa.
(Those
options are on one of the menus when you have the chart activated.)

--
Echo [MS PPT MVP]
http://www.echosvoice.com



I have to create a combo bar/line graph. I need the X-axis for both to


run

down vertically (like a typical bar graph). However, I cannot seem to


force

the line to run down vertically, it wants to stay on a horizontal axis


(makes

two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002

 

[Andy Pope]

No problem. Thanks for posting back.

Cheers
Andy

Wowzers! Now that is some workaround! I guess that where there's a will,
there's always a way. ;-)

That's a great idea, but since I'm only setting these up, and won't be the
one working on these, I'd better not make them to complicated. (can't
imagine trying to explain to a project person how to take their new data and
make this chart!)

Thanks very much for all your help! I will definitely keep this idea in
mind if I ever have to do one of these for myself - in a controlled
environment, namely mine, it'll work great.

:

Here you go. Hopefully a explanation you can understand.
http://www.andypope.info/ngs/ng43.htm

Cheers
Andy

Hi,

Ideally you would plot the dots as an xy scatter rather than a line but
MSGraph will not allow you to combine the two chart types.

As Echo suggests maybe use Excel, which will allow the combination.

For a PPT work around you could plot two extra data series on the
secondary axis as stacked bar. The first bar is used for padding. The
second bar has a custom fill to match required marker. You will need to
play around with the value for this to give the correct appearence for
your marker. The value of the pad bar will also have to be calculated to
align the marker in the correct place.

I will assemble an example and post back with the link.

Cheers
Andy

Smitty wrote:


Uh, no. I don't have a problem with the datasheet - all my data shows
up on the graph correctly, I can't force PPT to display it the way I
want it. Maybe this will help:
- Create a 2-series graph (dummy data, whatever)
- Change chart type to a simple clustered bar chart (not column) -
Select the 2nd series and change it's chart type to a line chart
Notice how the line takes itself off of the original y-axis and
creates a new secondary axis for it to use. Or think about it this
way, if you create this graph as a simple clustered column chart with
the second series as a line, then rotate the whole graph 90 degrees,
that's what I need.

Make more sense? Thanks!!

:



Try switching to Data by Column instead of Data by Row or vice versa.
(Those
options are on one of the menus when you have the chart activated.)

--
Echo [MS PPT MVP]
http://www.echosvoice.com




I have to create a combo bar/line graph. I need the X-axis for both to


run


down vertically (like a typical bar graph). However, I cannot seem to


force


the line to run down vertically, it wants to stay on a horizontal axis


(makes


two different x-axes)

For example:
Xxxxxx |----------------| O
Xxxxxx |------------------------| O
Xxxxxx |-----------------O-------------|

Not:
Xxxxxx |----------------| O O
Xxxxxx |------------------------| O
Xxxxxx |------------------------------|

Thank you very much!!

PPT 2002