+ Reply to Thread
Results 1 to 4 of 4

How do I number format the Data Table in an Excel Chart?

  1. #1
    Chartsmalm
    Guest

    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. #2
    owl37
    Guest

    RE: 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. #3
    Chartsmalm
    Guest

    RE: 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!!


  4. #4
    Tushar Mehta
    Guest

    Re: How do I number format the Data Table in an Excel Chart?

    You may also want to look at
    Custom Chart Table
    http://www.tushar-mehta.com/excel/ne...able/index.htm

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > 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!!
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1