K
ksgoodwin
I am trying to develop a pivot table from a set of data that describes 4
histograms. The data varies from .3 through 1.4 at increments of .05.
There are 4 sets of data. The frequency runs from 0 to ~80. The frequency
is different for each set of data.
Example:
1, 0, 5, 0, 10, 0, 0, 20, 45, 0, 0, 80, ...........
0
..3, .35, 0.4, .45, .50, .55, .60, .65, .70, .75, .80, .85 .......... 1.4
I can produce one pivot table, copy it 3 times and then populate the tables
with one data set each and get the frequency of the data and thus the
histogram. I use vlookup to get the data into one area so it is easy to
plot the 4 histograms together.
Question: I would like to make one pivot table without having to copy and
then do a vlookup to get the results.
Thoughts?
Ken
histograms. The data varies from .3 through 1.4 at increments of .05.
There are 4 sets of data. The frequency runs from 0 to ~80. The frequency
is different for each set of data.
Example:
1, 0, 5, 0, 10, 0, 0, 20, 45, 0, 0, 80, ...........
0
..3, .35, 0.4, .45, .50, .55, .60, .65, .70, .75, .80, .85 .......... 1.4
I can produce one pivot table, copy it 3 times and then populate the tables
with one data set each and get the frequency of the data and thus the
histogram. I use vlookup to get the data into one area so it is easy to
plot the 4 histograms together.
Question: I would like to make one pivot table without having to copy and
then do a vlookup to get the results.
Thoughts?
Ken