How can I rotate a chart, pasted from excel (linked data)?
Dont want to have to go through the whole thing of rotating every page that has a chart on it, making diffferent section breaks etc.
Has to be an easier way.
Oh, and making it a picture wont do, as it is a linked data chart.
Thanks in advance
You can create a textbox and place the chart in the textbox. Then rotate the textbox.
Last edited by teylyn; 08-21-2010 at 10:08 PM.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Doesnt Work
Any other ideas?
Works fine for me.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
"Doesn't work" is not good enough. I tested this in Office 2010 before posting the suggestion. It works.
It won't work in Office 2003, because you can't rotate a textbox. But you run 2010 according to your profile.
Explain what does not work.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
Apologies.
Someone else using my log in.
Original suggestion worked perfectly.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks