Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pie Charts not Printing colors correctly - Office 2007 | Charts and Charting in Excel | |||
Email address entered correctly | Excel Discussion (Misc queries) | |||
BUG: Charts are drawn in correctly in right-to-left spreadsheets | Charts and Charting in Excel | |||
How to correctly scale X-Axis in Charts? | Excel Discussion (Misc queries) | |||
Negative or zero values cannot be plotted correctly on log charts | Charts and Charting in Excel |