Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Aug 2006
    Location
    Gtr London, England
    Posts
    256
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Represent Data in Chart Format (Excel 2003)

    Hi,

    Ive got a column of dates on a spread sheet that I need to show in a pie chart, or any other chart format. The date column has various dates and the chart needs to show how many of each date. As matters stand the user makes use of the filter option on the column in question and selects as required, with a count showing on the lower toolbar. But showing the data in a pie chart format will let them see what dates are the most popular at a glance.

    Ive had a go using the chart wizard but the pie chart is showing all equal segments, Im not sure if its because the data is in a date format, i.e. 14/04/2007, that is causing the problem??

    Any pointer will be grately appreciated.

    Regards.
    Lee

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Represent Data in Chart Format (Excel 2003)

    How many distinct dates are there? A pie chart - if you want to use it at all - is hardly readable if the number of slices is large. And in general, it is hard to interpret. A column chart might be more suitable.

    You must create a table listing the frequency of each date; you could use a pivot table for that. See the attached sample workbook (you can change the chart to a pie chart if you like, but I wouldn't recommend it).
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Aug 2006
    Location
    Gtr London, England
    Posts
    256
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Represent Data in Chart Format (Excel 2003)

    Hi Hans,

    There are quiet a few distinct dates, probably in the region of 15. I'll have a look at the sample workbook and see how I get on.

    Many thanks for your time and help.

    Regards.
    Lee

  4. #4
    3 Star Lounger
    Join Date
    Aug 2006
    Location
    Gtr London, England
    Posts
    256
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Represent Data in Chart Format (Excel 2003)

    Hi Hans,

    The pivot table with a column chart works well, thanks for the advice. Just one thing though, how do I remove the unused, "Drop page field", boxes at the top and right hand side of the page?

    Regards.
    Lee

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Represent Data in Chart Format (Excel 2003)

    The chart is a pivot chart (a chart based on a pivot table); you cannot remove those boxes. They won't be printed, though.
    If you want to avoid the boxes, you must base the chart on a copy of the pivot table - see attached version.
    Attached Files Attached Files

  6. #6
    3 Star Lounger
    Join Date
    Aug 2006
    Location
    Gtr London, England
    Posts
    256
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Represent Data in Chart Format (Excel 2003)

    Thanks Hans,

    Ive never really used pivot tables before, so Im learning as I go.

    Many Thanks for your help.

    Best Regards.
    Lee

Posting Permissions

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