If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I number format the Data Table in an Excel Chart?
I prefer that the Data Table on a specific chart be formatted n,nnn,nnn as
all raw data is without cents. The cells used as reference for the chart are formatted in the above manner. On the worksheet where the chart is built the formnatting is n,nnn,nnn.00. The 00 is consistent because the data has no cents. The chart building workbook is a master that is used over and over for changing situations. So, the chart is copied to its own single sheet workbook for distribution and posterity. At this point the formatting problem gets worse. The commas disappear and now I have nnnnnnn - with no cents. Thank heaven that the 00 cents didn't come thru. The chart would have been absolutely unusable in that state. As it is we can use it as it is, with the explanation to the viewer: "Excel drops the commas. We're exploring the problem. You'll have to pen them in for now!" I can't believe that there is no way to control the fomat of this region when there is so much control over all other aspects of the chart building process. I simply cannot find it!!! Help!! |
#2
|
|||
|
|||
How do I number format the Data Table in an Excel Chart?
Hi,
THanks for your reply to my questions. Have a look at this website http://pubs.logicalexpressions.com/P...?ID=209#jon021 About data tables. Basically saying they are limited in what they can do and it is better to embed a chart and add in a data table manually. Hope this helps. Thanks. "Chartsmalm" wrote: I prefer that the Data Table on a specific chart be formatted n,nnn,nnn as all raw data is without cents. The cells used as reference for the chart are formatted in the above manner. On the worksheet where the chart is built the formnatting is n,nnn,nnn.00. The 00 is consistent because the data has no cents. The chart building workbook is a master that is used over and over for changing situations. So, the chart is copied to its own single sheet workbook for distribution and posterity. At this point the formatting problem gets worse. The commas disappear and now I have nnnnnnn - with no cents. Thank heaven that the 00 cents didn't come thru. The chart would have been absolutely unusable in that state. As it is we can use it as it is, with the explanation to the viewer: "Excel drops the commas. We're exploring the problem. You'll have to pen them in for now!" I can't believe that there is no way to control the fomat of this region when there is so much control over all other aspects of the chart building process. I simply cannot find it!!! Help!! |
#3
|
|||
|
|||
How do I number format the Data Table in an Excel Chart?
Thanks. It sounds as if the writer of that article has been down the path to
no solution within the chart process. I'm going to give the separate table approach a try. It sounds good. Thanks, again for the tip. "owl37" wrote: Hi, THanks for your reply to my questions. Have a look at this website http://pubs.logicalexpressions.com/P...?ID=209#jon021 About data tables. Basically saying they are limited in what they can do and it is better to embed a chart and add in a data table manually. Hope this helps. Thanks. "Chartsmalm" wrote: I prefer that the Data Table on a specific chart be formatted n,nnn,nnn as all raw data is without cents. The cells used as reference for the chart are formatted in the above manner. On the worksheet where the chart is built the formnatting is n,nnn,nnn.00. The 00 is consistent because the data has no cents. The chart building workbook is a master that is used over and over for changing situations. So, the chart is copied to its own single sheet workbook for distribution and posterity. At this point the formatting problem gets worse. The commas disappear and now I have nnnnnnn - with no cents. Thank heaven that the 00 cents didn't come thru. The chart would have been absolutely unusable in that state. As it is we can use it as it is, with the explanation to the viewer: "Excel drops the commas. We're exploring the problem. You'll have to pen them in for now!" I can't believe that there is no way to control the fomat of this region when there is so much control over all other aspects of the chart building process. I simply cannot find it!!! Help!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stop excel from dropping the 0 in the beginning of a number? | Rosewood | Setting up and Configuration | 11 | February 12th, 2006 01:38 AM |
Microsoft Access Limits (file size, table records, users) | Mike | General Discussion | 4 | November 4th, 2005 03:01 AM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |