Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Charts Don't Email Correctly

When I email a chart it changes the axis information from a date to a number
and the percentage signs change from percents to numbers. Is there an option
that I might not have set right.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Charts Don't Email Correctly

How are you emailing your chart? Usually a chart format is linked to the
source data (on the number format tab), but if you separate the chart from
its datasheet, it doesn't know what it should look like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Peco Worker" wrote in message
...
When I email a chart it changes the axis information from a date to a
number
and the percentage signs change from percents to numbers. Is there an
option
that I might not have set right.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Charts Don't Email Correctly

I created it in one workbook only using that information within that book and
then I copy the chart into a blank workbook and save it. Then I email the
workbook with only the chart in it.

"Jon Peltier" wrote:

How are you emailing your chart? Usually a chart format is linked to the
source data (on the number format tab), but if you separate the chart from
its datasheet, it doesn't know what it should look like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Peco Worker" wrote in message
...
When I email a chart it changes the axis information from a date to a
number
and the percentage signs change from percents to numbers. Is there an
option
that I might not have set right.




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Charts Don't Email Correctly

Before copying the chart, double click any text element, and on the Number
tab, uncheck the Linked to Source box. The chart should retain the
formatting, even when copied to another workbook and separated from the
original.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Peco Worker" wrote in message
...
I created it in one workbook only using that information within that book
and
then I copy the chart into a blank workbook and save it. Then I email the
workbook with only the chart in it.

"Jon Peltier" wrote:

How are you emailing your chart? Usually a chart format is linked to the
source data (on the number format tab), but if you separate the chart
from
its datasheet, it doesn't know what it should look like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Peco Worker" wrote in message
...
When I email a chart it changes the axis information from a date to a
number
and the percentage signs change from percents to numbers. Is there an
option
that I might not have set right.






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
Pie Charts not Printing colors correctly - Office 2007 Gary Charts and Charting in Excel 0 October 4th 07 08:40 PM
Email address entered correctly lv Excel Discussion (Misc queries) 0 June 20th 07 07:06 PM
BUG: Charts are drawn in correctly in right-to-left spreadsheets Yuval Rakavy Charts and Charting in Excel 0 May 25th 06 10:18 AM
How to correctly scale X-Axis in Charts? Peter Bernadyne Excel Discussion (Misc queries) 3 December 20th 05 09:47 PM
Negative or zero values cannot be plotted correctly on log charts NTE Charts and Charting in Excel 6 December 11th 05 05:27 AM


All times are GMT +1. The time now is 07:42 AM.

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

About Us

"It's about Microsoft Excel"