Replies

ok, thank you very much. I have it all working, see attached. I’ve given up on the Xcelsius tool, it keeps bombing so now i am trying to design a form in vba.

How do I control the Chart on the UserForm1? I want the user to be able to choose an item from the listbox (choose up to 5) and then have the chart show them the results (like on Chart1) chartsheet. Would this be the best way for the user to see the results of their choice in a chart format? How do I manipulate the chart control on the form? Thank you.

This works perfectly, but there is a twist here. I am using a product called Xcelsius that uses underlying Excel files. I linked this worksheet to Xcelsius and it bombed so I called the vendor and they said they do not support the Row Excel function. Therefore, is there another way to do this without using Row?

I’ve worked out this way of doing it. Is there a way to add formulas (perhaps vlookup) to A1:B5 so that if a number is entered in B6 that represents one of the 5 categories, that the top 5 of that cat/column will be displayed in A1:B5?

No, they are not unique. They are percentages that could be duplicated.

ok, thank you.

Also, i now realize I have to pull the matching text in COL A that goes with the highest number. So if Red is 99% and falls in B47, then B1 will have 99% in it. How can I get A1 to have the word Red in it?

yes, it worked perfectly. Thank you very much.

oops

When I enter

A (NOT 100,000
A and B 50,000
B (NOT A) 50,000

It seems like the right circle should be 66.7% (B=100,000) of the size of the left circle since A=150,000. The right circle is a lot larger than 67% of the left circle. How are the circle sizes calculated? thank you for the help.

You are too kind!

oh my goodness. This is TOOOO wonderful.

Is there a way it can be changed to keep them perfect circles? When i use

5,006,000
18,727,000
6,905,000

the circles come out round. When i use
8,749,000
5,544,000
3,162,000

they are oblong.

I’ve looked everywhere for a solution like this. I can’t believe all the calculations. I would love to do circles but may switched to stacked bars to keep it simple since i have to do 30 of them. Thank you so much.

I did read the old posts but completely missed your sample. I have 30 venns with only 2 circles. I tried to modify for 2 cicles but frankly got lost. Can you help me? thanks

yes, it is a good way but there is no automated way to make the 2 circles propotionate and data labels to appear in the center of the 2 circles in addition to the “overlapped” section. I have to do 30 of them a month and want to automatically make them. Is the stacked bar the best 2nd choice? thanks

i changed to
shp.height = 320 and shp.height = 54 and now it works. go figure

thank you very much. Seems like it should work but it’s not finding them. The textbox is 4.45″ height with a width of 7.11″. I changed the code to 4.45 instead of 4.75 but it still doesn’t find them.

The delimited file that is being converted does have the word “base” in it. It runs fine on my pc with win xp and excel 2003 sp2. When it runs on her pc it gets that type 9 error. She has office 2002 on windows 98. I was wondering if there are differences in excel 2002 to excel 2003 like the colorindex property, the pagebreak property constants, for maybe the border type constants (xlEdgeLeft etc).