Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    Making a chart (Excel 203)

    Hi all...I am trying to make a chart to show comparative values....at work we have 2 groups who donate money to the local food bank to buy Christmas turkeys for less fortunate folks...I am attaching a sample of the file that I have composed so far; I can't seem to get the data to flip over into the chart...I want to show comparative values (between groups A and [img]/forums/images/smilies/cool.gif[/img] for all years since 2003....you enter the number of donors (eg: in J8, J9, J17, J18 and so on) and you enter dollar amounts in K9, K18...the yellow squares.....I want this data to show up in the bar chart....what am I missing when I compose the bar chart?
    Attached Files Attached Files

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

    Re: Making a chart (Excel 203)

    You should place the data in a contiguous range, otherwise it's difficult to get things right. See attached version. You can hide columns S:U on the Collected sheet if you want.
    Attached Files Attached Files

  3. #3
    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

    Re: Making a chart (Excel 203)

    Not sure what you are after. Here is an example with a stacked column separating the 2 types (A/[img]/forums/images/smilies/cool.gif[/img] as well as the amounts

    Steve
    Attached Files Attached Files

  4. #4
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Making a chart (Excel 203)

    This looks great, Steve...how do I get rid of the "empty" (or blank) column?

  5. #5
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Making a chart (Excel 203)

    Thank you, Hans...as always, you are a genius...

  6. #6
    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

    Re: Making a chart (Excel 203)

    The blank columns in the charts can be deleted by deleting the blank rows in the source data. I put them in to separate the years and the chart edges. They are not required.

    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
  •