Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
My chart in excel contains 12 years across the x axis and needs to be in
landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
PSometine you can't go directly from point A to Point B witthout going to
point C. This is one case. Copy the picture into from excel and Paste Special into Power Point as an enhanced meta file. Then copy again from Power Point into word. "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
Why not just change that page to landscape in the word document or paste
special it into word as an image and use the drawing toolbar to rotate it -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
John : Did you try to take a chart directly from Excel into word and paste
special before you answered this Posting? It doesn't work. that is why I recommended pasting into Visio first. "John" wrote: Why not just change that page to landscape in the word document or paste special it into word as an image and use the drawing toolbar to rotate it -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
Yep & I have just tested it again. Paste as a picture and you can rotate it
to any angle you like. If you like you can copy the chart and paste it as a picture in Excel then rotate it there and you can then copy & paste it into Word and it will be at the same angle in both -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Joel" wrote: John : Did you try to take a chart directly from Excel into word and paste special before you answered this Posting? It doesn't work. that is why I recommended pasting into Visio first. "John" wrote: Why not just change that page to landscape in the word document or paste special it into word as an image and use the drawing toolbar to rotate it -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
Help! Help! Help
there is something inconsistant about Paste Special. I pasted an excel chart twice this morning as a Enhanced Meta File but didn't get the option to rotatte this item. It works if you first Paste the items in Power Point and then copy into word. There have been plenty of time in the past where I had simialr type problems with different Microsoft Office Products copying and pastting pictures. My solution has been to go into Power Point and do the Paste Special in Point. Do you know why this occurs? It been bugging the hell out of me. I made a simple X-Y scater chart using 8 points (2 column x 4 rows) and used the standard settings. Then copied the chart into word and did paste special meta file. I didn't get the rotation bar on the graph. Did the same thiing into Power Point and it eworked perfectly. then copied from Power Point into Word and everything worked!!!!!!!!!!!!!!!!!!!!!!!! "John" wrote: Yep & I have just tested it again. Paste as a picture and you can rotate it to any angle you like. If you like you can copy the chart and paste it as a picture in Excel then rotate it there and you can then copy & paste it into Word and it will be at the same angle in both -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Joel" wrote: John : Did you try to take a chart directly from Excel into word and paste special before you answered this Posting? It doesn't work. that is why I recommended pasting into Visio first. "John" wrote: Why not just change that page to landscape in the word document or paste special it into word as an image and use the drawing toolbar to rotate it -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
I don't know why it isn't working for you. I just did as John suggested,
pasted the copied chart into Word as a picture, then rotated using the button on the Picture toolbar. No problem. It's worked this way since at least Office 97, perhaps earlier. I hope you don't need to reinstall Office, but that might be the answer. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Joel" wrote in message ... Help! Help! Help there is something inconsistant about Paste Special. I pasted an excel chart twice this morning as a Enhanced Meta File but didn't get the option to rotatte this item. It works if you first Paste the items in Power Point and then copy into word. There have been plenty of time in the past where I had simialr type problems with different Microsoft Office Products copying and pastting pictures. My solution has been to go into Power Point and do the Paste Special in Point. Do you know why this occurs? It been bugging the hell out of me. I made a simple X-Y scater chart using 8 points (2 column x 4 rows) and used the standard settings. Then copied the chart into word and did paste special meta file. I didn't get the rotation bar on the graph. Did the same thiing into Power Point and it eworked perfectly. then copied from Power Point into Word and everything worked!!!!!!!!!!!!!!!!!!!!!!!! "John" wrote: Yep & I have just tested it again. Paste as a picture and you can rotate it to any angle you like. If you like you can copy the chart and paste it as a picture in Excel then rotate it there and you can then copy & paste it into Word and it will be at the same angle in both -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Joel" wrote: John : Did you try to take a chart directly from Excel into word and paste special before you answered this Posting? It doesn't work. that is why I recommended pasting into Visio first. "John" wrote: Why not just change that page to landscape in the word document or paste special it into word as an image and use the drawing toolbar to rotate it -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
I don't think I have to re-install office. When I drop a picture directly
into word the rotation line doesn't show up on the picture. I does if I go into Power Point first. I just foiund another trick. If I drop the picture into work I can rotate it left 90 degees. Then the rotation line appear and I can then rotate the picture to any angle. Not sure why? "Jon Peltier" wrote: I don't know why it isn't working for you. I just did as John suggested, pasted the copied chart into Word as a picture, then rotated using the button on the Picture toolbar. No problem. It's worked this way since at least Office 97, perhaps earlier. I hope you don't need to reinstall Office, but that might be the answer. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Joel" wrote in message ... Help! Help! Help there is something inconsistant about Paste Special. I pasted an excel chart twice this morning as a Enhanced Meta File but didn't get the option to rotatte this item. It works if you first Paste the items in Power Point and then copy into word. There have been plenty of time in the past where I had simialr type problems with different Microsoft Office Products copying and pastting pictures. My solution has been to go into Power Point and do the Paste Special in Point. Do you know why this occurs? It been bugging the hell out of me. I made a simple X-Y scater chart using 8 points (2 column x 4 rows) and used the standard settings. Then copied the chart into word and did paste special meta file. I didn't get the rotation bar on the graph. Did the same thiing into Power Point and it eworked perfectly. then copied from Power Point into Word and everything worked!!!!!!!!!!!!!!!!!!!!!!!! "John" wrote: Yep & I have just tested it again. Paste as a picture and you can rotate it to any angle you like. If you like you can copy the chart and paste it as a picture in Excel then rotate it there and you can then copy & paste it into Word and it will be at the same angle in both -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Joel" wrote: John : Did you try to take a chart directly from Excel into word and paste special before you answered this Posting? It doesn't work. that is why I recommended pasting into Visio first. "John" wrote: Why not just change that page to landscape in the word document or paste special it into word as an image and use the drawing toolbar to rotate it -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Rotation
That's an easier workaround than using PowerPoint first. I'd say, cut your
losses, accept it, and don't hurt your head wondering why! - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Joel" wrote in message ... I don't think I have to re-install office. When I drop a picture directly into word the rotation line doesn't show up on the picture. I does if I go into Power Point first. I just foiund another trick. If I drop the picture into work I can rotate it left 90 degees. Then the rotation line appear and I can then rotate the picture to any angle. Not sure why? "Jon Peltier" wrote: I don't know why it isn't working for you. I just did as John suggested, pasted the copied chart into Word as a picture, then rotated using the button on the Picture toolbar. No problem. It's worked this way since at least Office 97, perhaps earlier. I hope you don't need to reinstall Office, but that might be the answer. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Joel" wrote in message ... Help! Help! Help there is something inconsistant about Paste Special. I pasted an excel chart twice this morning as a Enhanced Meta File but didn't get the option to rotatte this item. It works if you first Paste the items in Power Point and then copy into word. There have been plenty of time in the past where I had simialr type problems with different Microsoft Office Products copying and pastting pictures. My solution has been to go into Power Point and do the Paste Special in Point. Do you know why this occurs? It been bugging the hell out of me. I made a simple X-Y scater chart using 8 points (2 column x 4 rows) and used the standard settings. Then copied the chart into word and did paste special meta file. I didn't get the rotation bar on the graph. Did the same thiing into Power Point and it eworked perfectly. then copied from Power Point into Word and everything worked!!!!!!!!!!!!!!!!!!!!!!!! "John" wrote: Yep & I have just tested it again. Paste as a picture and you can rotate it to any angle you like. If you like you can copy the chart and paste it as a picture in Excel then rotate it there and you can then copy & paste it into Word and it will be at the same angle in both -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Joel" wrote: John : Did you try to take a chart directly from Excel into word and paste special before you answered this Posting? It doesn't work. that is why I recommended pasting into Visio first. "John" wrote: Why not just change that page to landscape in the word document or paste special it into word as an image and use the drawing toolbar to rotate it -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "GatorGirl" wrote: My chart in excel contains 12 years across the x axis and needs to be in landscape orientation to clearly see the years. However, I need to copy the chart into a word document and for the years to be clear, the entire charts needs to be rotated 1/4 turn counter clockwise. How can I copy and paste to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
Team Role Rotation (number of team members is variable) | Excel Worksheet Functions | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
How do I set up a euchre rotation schedule | Excel Worksheet Functions | |||
Schedule Rotation Question | Excel Worksheet Functions |