data table for pie
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: data table for pie

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello all,
    I know I can display the data table on column charts , but can I do the same with pie chart?


  2. #2
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-07-14 02:00, Target wrote:
    Hello all,
    I know I can display the data table on column charts , but can I do the same with pie chart?

    No, There is no such "built-in" posibility in Pie Chart Options.

    Eli

    [ This Message was edited by: eliW on 2002-07-14 05:04 ]

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Target

    Create a copy of your Pie chart

    Change it's type to 'whatever'

    Set it so it has a Data Table

    Place it over the top of your Pie Chart, with just the Data Table extending below the Pie Chart.

    Right click on the copied chart and send to back.

    Select both charts, right click and Group.




  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I suppose you can also use the camera option, which you can resize the data table into your chart quite nicely..... it remains realtime, so any adjustments update the image.

    view
    toolbars
    customise
    commands
    tools
    camera icon (3rd from bottom)- drag to your tooolbar

    highlight data table
    say cheese
    click on camera
    click and drag image to size on your pie chart

    to format this image, right click it and then choose "format picture" - you can play around with the lines, opaqueness etc etc






    :: Pharma Z - Family drugstore ::

  5. #5
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    11,007
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

    Since I have never really liked XL's handling of the data table, I've used an alternative. Just below the chart, create a copy of the data plotted on the chart (one way would be to copy the original data set, click the cell where you want the table to appear, Edit | Paste Special... | Link. Now, format the pasted data as desired -- with far greater flexibility than a Data Table can provide -- and it will look like the chart has a data table!

    On 2002-07-14 02:00, Target wrote:
    Hello all,
    I know I can display the data table on column charts , but can I do the same with pie chart?


  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks to all
    I tried the camera method and it works just the way I needs .
    Any other special use for the camera icon?

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How long's a piece of string ?



    try a search on my name with "camera" in the search field... you'll get most of my thoughts on it

    I find it handiest for presenting different-shaped summaries all in one go where normally trying to align then via column widths and merging would drive you nuts...

    (I'm not sure it has any advantages over Tusharm's link paste though, and Daves "group" suggestion is new to me too, I like it...... you could have intertwining images (like in set-theory) n stuff


    :: Pharma Z - Family drugstore ::

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com