Trouble copying graphs

G

galatea2153

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
 
B

Bernard Liengme

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
 
G

galatea2153

Thanks Bernard, it worked great!

Megan

Bernard Liengme said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top