Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Feb 2009
    Posts
    308
    Thanks
    0
    Thanked 1 Time in 1 Post
    I have a chart in Excel but I cannot click on/edit each individual cell in the chart data table. There two column, eight rows apiece, of dollar amounts, and I need to center these amounts and decimal align them. I know how to do this in Word 2007, primarily because I have editing capabilities within each individual cell. Here, I am clueless, and Excels built-in help glossary returned no helpful answers to my question.

    Anyone?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Not only can you not change the alignment you can't change the position of the data table (which used to be possible).
    I have a solution, however I will note that centering and decimal aligning are mutually impossible.

    And the data table doesn't appear to update when the numbers change... or am I missing something?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    [quote name='WebGenii' post='774143' date='07-May-2009 11:00']And the data table doesn't appear to update when the numbers change... or am I missing something?[/quote]

    Oops had manual calculation turned on.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    3 Star Lounger
    Join Date
    Feb 2009
    Posts
    308
    Thanks
    0
    Thanked 1 Time in 1 Post
    Should have clarified that I know which field within the Excel worksheet the numbers in the chart are drawn from, and was attempting to make the decimal alignment changes there, but no luck.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    In short my answer is to create a picture of the data set, then paste the picture into the chart.

    It can be positioned anywhere you wish on the chart and with a bit of fooling around you can get your centered decimal aligned data.
    Drawback: anytime your source data updates you will need to repaste the picture into the chart. As you can't create a linked picture in a chart.

    (That is what I've been testing).
    If you need more detailed instructions - let me know.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    3 Star Lounger
    Join Date
    Feb 2009
    Posts
    308
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    [quote name='WebGenii' post='774143' date='07-May-2009 13:00']I will note that centering and decimal aligning are mutually impossible.[/quote]

    That is not true unless XL2007 changed formatting options from previous versions. If you use a custom format with the question mark for the "optional characters", you can center and decimal align (it will be centered for the longest sequence): the format is a variant (depending on total characters and number of decimals):

    ???,??0.00

    The question mark will leave the space for the charcter even if that character is not used in the value itself...

    Steve

Posting Permissions

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