Switch column/row in spreadsheet when PowerPoint charting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When creating a chart in PowerPoint, is there a way to swap columns and rows
in the spreadsheet part before entering the data (I'm copying/pasting data
from an existing worksheet in which the series are horizontal rather than
vertical) or do I have to paste the data horizontally (the "wrong"
arrangement) then use the Switch Row/Column button in PowerPoint?

I'd prefer to set up the table properly and do the switching in the
spreadsheet before pasting the data but maybe that's not the best way to do
it.

Thanks,

liz
 
I'd do the swapping in Excel. Copy the cells, choose another cell and Edit |
Paste Special (or right-click and paste special). Choose Values and check
the "transpose" option at the bottom.
 
Echo,

Swapping in Excel really isn't a good option in this situation. I'm
cherry-picking info from three rows in a larger spreadsheet. That would be
another step in an already long process.

It won't hurt the students to learn to use the Switch Row/Column feature of
PowerPoint. I was just hoping that I could do it in the datasheet/spreadsheet
part rather than in the chart part.

Thanks for your suggestion, though.

liz



Echo S said:
I'd do the swapping in Excel. Copy the cells, choose another cell and Edit |
Paste Special (or right-click and paste special). Choose Values and check
the "transpose" option at the bottom.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/


Elizabeth Swoope said:
When creating a chart in PowerPoint, is there a way to swap columns and
rows
in the spreadsheet part before entering the data (I'm copying/pasting data
from an existing worksheet in which the series are horizontal rather than
vertical) or do I have to paste the data horizontally (the "wrong"
arrangement) then use the Switch Row/Column button in PowerPoint?

I'd prefer to set up the table properly and do the switching in the
spreadsheet before pasting the data but maybe that's not the best way to
do
it.

Thanks,

liz
Click to expand...
Click to expand...
 
It won't hurt the students to learn to use the Switch Row/Column feature
of
PowerPoint. I was just hoping that I could do it in the
datasheet/spreadsheet
part rather than in the chart part.
Click to expand...

Oh, I guess I didn't quite understand what you were asking. You can switch
rows/columns in PPT's MS Graph datasheet. Choose Data | Series in Rows or
Series in Columns. There are two buttons that match those on the menu on the
toolbars as well. They do the same thing.
 
Echo,

When I create a graph in PowerPoint, the left half of my screen is the
PowerPoint slide and menu and the right half is the datasheet in Excel.

The DATA tab on the Excel side doesn't show anything about series and there
aren't any buttons on my toolbar for that. There is a Switch Row/Column
button on the PowerPoint side, and clicking that does swap the rows/columns
on the graph but not in the datasheet. Looks like I'm stuck with series in
columns and categories in rows there.

It's not a huge problem. As long as I know what the behavior is, I can
describe it to the students and it will be fine. I just wanted to be sure
that there wasn't a way to make the data look right in the datasheet.

Thanks so much for all your help. Your input is very useful.

liz
 
I'm sorry, Liz -- I totally forgot you're using PPT 2007. Of course, you are
correct. PPT 2007 uses Excel for its charting, so the rows/columns swaps
would be there. And, as you already explained, that's not a good solution
for a couple of reasons.

Sorry to throw you a red herring!

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/


Elizabeth Swoope said:
Echo,

When I create a graph in PowerPoint, the left half of my screen is the
PowerPoint slide and menu and the right half is the datasheet in Excel.

The DATA tab on the Excel side doesn't show anything about series and
there
aren't any buttons on my toolbar for that. There is a Switch Row/Column
button on the PowerPoint side, and clicking that does swap the
rows/columns
on the graph but not in the datasheet. Looks like I'm stuck with series in
columns and categories in rows there.

It's not a huge problem. As long as I know what the behavior is, I can
describe it to the students and it will be fine. I just wanted to be sure
that there wasn't a way to make the data look right in the datasheet.

Thanks so much for all your help. Your input is very useful.

liz

Echo S said:
Oh, I guess I didn't quite understand what you were asking. You can
switch
rows/columns in PPT's MS Graph datasheet. Choose Data | Series in Rows or
Series in Columns. There are two buttons that match those on the menu on
the
toolbars as well. They do the same thing.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
Click to expand...
Click to expand...
 
Echo,

No apology necessary! I know how hard it is to keep track of versions and to
keep track of conversations when you are helping lots of people.

I was hoping that I was just missing something--that happens. I truly want
to like Office 2007 but I have never liked Office and this version is more of
the things I don't like and fewer of the (already few) things I do. I'm
seeing lots of whipped cream, sprinkles, and the cherry on the top but
there's no ice cream under all that fluff.

I'm delving into Access now. That's the only MS product that I really kind
of like. It's going to take some getting used to. Then I'll tackle Word,
which I hated so much in beta that I quit working with the beta.

(Excel and 1-2-3 are just different sides of the same coin to me, but I
detest Word and PowerPoint. Although Word Pro and Freelance are ancient in
computer-years, they're lots easier to use and are faster and more efficient
to work with.)

liz
 
but I have never liked Office

Tsk ... one of those *Lotus* people.

Hi Elizabeth.

-----------------------------------------
Steve Rindsberg, PPT MVP

(And former L-Team member) ;-)

PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
 
Back
Top