Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Randomly Generate Specific Data
FB1
FB2 FB3 00 01 02 03 04 05 FB4 0 C1 1 C2 2 C3 3 C4 4 PO 5 PO1 PO2 PO3 CU1 CU2 CU3 CU4 I have created a random generator to place the data on the left into the chart above. I would like to add a percentage stop, ie: CU4 is only 7% of the data in the chart. I would then like to create another grid that places the row and column numbers associated with the data. ie: if if 022 is FB1, I would like FB! to be placed in another chart that shows how many of each data point has been placed. Help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Randomly Generate Specific Data
You started getting questions in your other post. This layout is not any
clearer. What is 022, how do we know CU4 is only 7% what does FB1-4 C1-4 PO1-3 and CU1-4 represent? How are the numbers to the right come up with? What are you trying to accomplish. And, oh yeah, please do not multipost :) -- ** John C ** "Bill" wrote: FB1 FB2 FB3 00 01 02 03 04 05 FB4 0 C1 1 C2 2 C3 3 C4 4 PO 5 PO1 PO2 PO3 CU1 CU2 CU3 CU4 I have created a random generator to place the data on the left into the chart above. I would like to add a percentage stop, ie: CU4 is only 7% of the data in the chart. I would then like to create another grid that places the row and column numbers associated with the data. ie: if if 022 is FB1, I would like FB! to be placed in another chart that shows how many of each data point has been placed. Help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Randomly Generate Specific Data
The percentages are created by me. 022 is the column / row that the data
point appears in. The data set on the far left is text that I am randomly assigning into the block and do not want more than certain percentages of each data point "John C" wrote: You started getting questions in your other post. This layout is not any clearer. What is 022, how do we know CU4 is only 7% what does FB1-4 C1-4 PO1-3 and CU1-4 represent? How are the numbers to the right come up with? What are you trying to accomplish. And, oh yeah, please do not multipost :) -- ** John C ** "Bill" wrote: FB1 FB2 FB3 00 01 02 03 04 05 FB4 0 C1 1 C2 2 C3 3 C4 4 PO 5 PO1 PO2 PO3 CU1 CU2 CU3 CU4 I have created a random generator to place the data on the left into the chart above. I would like to add a percentage stop, ie: CU4 is only 7% of the data in the chart. I would then like to create another grid that places the row and column numbers associated with the data. ie: if if 022 is FB1, I would like FB! to be placed in another chart that shows how many of each data point has been placed. Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
generate randomly assigned lists | New Users to Excel | |||
Use Excel to randomly generate selections for cyle counting? | Excel Worksheet Functions | |||
Generate column of 1's and 0's randomly | Excel Discussion (Misc queries) | |||
How to generate a list of randomly selected numbers within a range | Excel Worksheet Functions | |||
How can I generate 10 sites randomly from a worksheet | Excel Discussion (Misc queries) |