Trouble copying graphs
Hi,
I'm using Excel 2003 and 2007 (not same machine), on Windows XP. Each month I create a graph showing some statistics, which I then copy into a new worksheet, add a few more graphs, and then send off to someone else. Either when I first copy the graph, or when I send it, all the dates on the graph change. Let's say my original graph starts at Jan, then Feb, then March etc. On the copy, the months will start at Feb, then March etc. Often the years change too - reverting to 2003 seems to be common. I'm not sure why this is happening - am I forgetting to do some basic thing to keep all the months as they are on the original? By the way, all the data remains the same - just the dates change. Many thanks Megan |
Trouble copying graphs
Why not send a picture of the chart.
Click chart Hold down Shift Use Menu item Edit; select Copy as Picture Move to new document and Paste best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "galatea2153" wrote in message ... Hi, I'm using Excel 2003 and 2007 (not same machine), on Windows XP. Each month I create a graph showing some statistics, which I then copy into a new worksheet, add a few more graphs, and then send off to someone else. Either when I first copy the graph, or when I send it, all the dates on the graph change. Let's say my original graph starts at Jan, then Feb, then March etc. On the copy, the months will start at Feb, then March etc. Often the years change too - reverting to 2003 seems to be common. I'm not sure why this is happening - am I forgetting to do some basic thing to keep all the months as they are on the original? By the way, all the data remains the same - just the dates change. Many thanks Megan |
Trouble copying graphs
Thanks Bernard, it worked great!
Megan "Bernard Liengme" wrote: Why not send a picture of the chart. Click chart Hold down Shift Use Menu item Edit; select Copy as Picture Move to new document and Paste best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "galatea2153" wrote in message ... Hi, I'm using Excel 2003 and 2007 (not same machine), on Windows XP. Each month I create a graph showing some statistics, which I then copy into a new worksheet, add a few more graphs, and then send off to someone else. Either when I first copy the graph, or when I send it, all the dates on the graph change. Let's say my original graph starts at Jan, then Feb, then March etc. On the copy, the months will start at Feb, then March etc. Often the years change too - reverting to 2003 seems to be common. I'm not sure why this is happening - am I forgetting to do some basic thing to keep all the months as they are on the original? By the way, all the data remains the same - just the dates change. Many thanks Megan |
All times are GMT +1. The time now is 12:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com