Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble copying info into a spreadsheet Meenie Excel Worksheet Functions 9 March 20th 07 06:13 PM
TROUBLE COPYING AND PASTING FORMULAS belga Excel Worksheet Functions 2 July 3rd 06 04:03 AM
Charts/ Graphs and Dates Trouble Heyna Charts and Charting in Excel 0 February 23rd 06 11:00 PM
Charts/ Graphs and Dates Trouble Heyna Excel Discussion (Misc queries) 0 February 23rd 06 08:31 PM
having trouble with graphs Davko Excel Discussion (Misc queries) 1 April 25th 05 03:28 AM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"