Re: Graph - axis switching for a line graph

Tech-Archive recommends: Fix windows errors by optimizing your registry

Smitty wrote:
> 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!

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


.

Relevant Pages

  • Re: Excel imports into Word
    ... If you are pasting the Excel spreadsheets into Word as Excel objects, ... then you cannot rotate them. ... has to be shrunk more than 69% to fit within the margins of the Word ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Subreport rotation
    ... How hard would it be to export it to excel and rotate the part I need ... Providing Customers A Resource For Help With Access, Excel And Word ... In a crosstab query, you can specify ... post some sample data from your subform. ...
    (microsoft.public.access.reports)
  • Re: Rotating Entire Presentation
    ... but want the screen to be mounted sideways instead of in ... but that doesn't do anything for the background templates. ... it should be able to rotate the images 90 degrees ... Steve Rindsberg, PPT MVP ...
    (microsoft.public.powerpoint)
  • Re: Excel Tables in Word
    ... > and sign-off blocks) and my footer in the portrait orientation. ... > then be able to bring in the excel tables and rotate them to fit my page. ...
    (microsoft.public.word.docmanagement)
  • Re: Flip text box 180 degrees
    ... I have Excel 2000 SP3. ... I'm not able to rotate. ... It seems to be recognized as a picture which should ... > click somewhere on the worksheet, ...
    (microsoft.public.excel.misc)