Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Jul 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bar Chart in two cells not sized per percentages (MS Excel 2002)

    Hello,
    I have been having an issue with a spreadsheet that I have attached. I want a bar chart next to column C illustrating the percentages there in column D. I believe I am SO close. However, the bar is showing "Point 2 above point 1 in the Series"- which is incorrect. If anyone can help- show me the error of my ways- I would truly appreciate your efforts.

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

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    Welcome to Woody's Lounge!

    The chart is displaying the default behavior: the vertical axis points upwards. Since you have hidden the axes, you must do the following:

    - Click on a chart.
    - Select Chart | Chart Options...
    - Activate the Axes tab.
    - Tick the check box "Category axis".
    - Click OK.
    - Select "Category Axis" from the Chart Objects dropdown on the Chart toolbar.
    - Select Format | Selected Axis...
    - Activate the Scale tab.
    - Tick the check box "Categories in reverse order".
    - Click OK.
    - Select Chart | Chart Options...
    - Activate the Axes tab.
    - Clear the check box "Category axis".
    - Click OK.

    You'll have to repeat this for each chart with two bars.

  3. #3
    New Lounger
    Join Date
    Jul 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    Thank you for your reply.
    All was good until the 6th item- I do not have "Category Axis" as an option. I have Chart area, Plot area, and Series 2. How can I change this? Also, will this always make the 2nd item above? I want to be sure that the % in Column C reflects the graph being created in D - whether the first or second item is a higher percentage.

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

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    Unfortunately, the charts have been set up inconsistently, this makes it hard to treat them the same way. In the attached version, I have deleted all but one chart, set up the one the way I wanted, then copied it 8 times and changed the source data of the copies. All charts now behave the same way.

  5. #5
    New Lounger
    Join Date
    Jul 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    THANK YOU SO MUCH. That is perfect. YOU are wonderful.

  6. #6
    New Lounger
    Join Date
    Jul 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    Hello again,
    I have another excel sheet that I wnat the charts done just like the last time (In July) that you helped me with. Would you be able to look at this sheet? I did not try the charts, since last time it was a mess that you fixed. I have attached the file, it looks similar to the one in July, but this time there are 20 charts/questions. I would really appreciate your review and tell me the best way to make this work. HOWEVER, I have tried to attach the file and it is 112K too big to attach this way. Is there a way I can send it to you directly?

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

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    Try zipping the file and attaching the zip file.

  8. #8
    New Lounger
    Join Date
    Jul 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    I don't have WinZip. I went to their website and they want you to pay for it now.

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

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    Which version of Windows do you have? In Windows XP, zipping is built in: right-click the workbook in Windows Explorer and select Send To > Compressed Folder.

    Otherwise: you can still download a free evaluation version of WinZip - click "Try Now" on the WinZip home page. One of the free alternatives is 7-Zip.

  10. #10
    New Lounger
    Join Date
    Jul 2006
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    OK- thanks for your help with finding a Zip. See the folder attached for the file.

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

    Re: Bar Chart in two cells not sized per percentages (MS Excel 2002)

    You'll have to learn how to do this yourself - we can't create the charts for you each time you change something. It is rather annoying work because the charts are tiny, so that it is hard to select what you want.

    The idea is as follows:
    - Click on a chart.
    - Make sure that you have selected the chart area, not the plot area. You can select 'Chart Area' from the dropdown on the Chart toolbar.
    - Copy (Ctrl+C)
    - Click outside the chart.
    - Paste (Ctrl+V)
    - Drag the copy to its new location. If you hold down Alt while dragging, the chart will align with the cell edges.
    - If necessary, resize the chart. This is finicky, for it's very easy to select the plot area instead of the chart area. Again, holding down Alt will let you align the chart with cell edges.
    - If necessary, you can also resize the plot area within the chart area.
    - Select Chart | Source Data.
    - Click in the Values box.
    - Select the range in column C that contains the values for this chart.
    - Click OK.

    I have done a few for you using this method. You'll have to do the rest yourself. Good luck!

Posting Permissions

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