Results 1 to 2 of 2

Thread: Excel Charts

  1. #1
    3 Star Lounger rcbjr2's Avatar
    Join Date
    Jan 2001
    Location
    Matthews, NC
    Posts
    279
    Thanks
    6
    Thanked 1 Time in 1 Post

    Excel Charts

    I've looked through Help, but I'm confused about creating a Chart in Excel 2000. I have a spreadsheet of leases. One column has expiration dates. Most cells are Excel dates, but some have "Mo to Mo" in them (for month to month terms). I'd like to create a pie chart or bar graph showing the number of lease expiring in each year. I've been inserting charts, but I haven't been getting a pie (and maybe it's because out of the 200 or so leases, each expires on a different date and the chart can't handle that data). I would appreciate some suggestions on how to go about doing creating a chart of expirations dates by year only.

    Thx.

    -Rich Belthoff

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel Charts

    Is it possible to give more details on the spreadsheet. If the data is not confidential would it be possible to attach a sample of the data to work with?
    Regards,
    Rudi

Posting Permissions

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