Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I am including the worksheet Graphing Data which has two sections one for 2008 and one for 2009. Each section has the name of the item and total # sales, # OF cash sales, # OF credit card sales, total $ payments, % of # of cash sales to # of total sales.

    I would like to do a bar graph showing by item the comparative % of # of cash sales to # of total sales 2008 bar VS 2009 bar.


    Could anyone give me an idea on what to do?
    Attached Files Attached Files

  2. #2
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Hi,

    Does this do what you want? I added a third set showing the difference between the two years and then graphed the comparative data only.

    Regards,
    Maria
    Attached Files Attached Files
    Maria
    Simmo7
    Victoria, Australia

Posting Permissions

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