Hello, I got help before and was able to create graphs from three groups of data which I am comparing and now I am
wondering if there is a simple way to include a visualisation of the MEAN and STANDARD DEVIATION values into these graphs for each group?
Check my example on what I have right now.
With a pivot table and pivot graph.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I went slightly different way. using simple formulas similar to:
Formula:
Please Login or Register to view this content.
for 9 additional series - Average, average - std dev and average + stnd dev for each group and showing these series as line graph.
Best Regards,
Kaper
Hello, something like this would work but im unsure if its the right data so im just checking one last time here, In the edited file I have added in this reply there is a new red box
that computes the data from the Data/IT group and gives the mean/average and Standard deviation/STDAV from that group.
Im not sure but does the things you added visualise these numbers for that group in the chart or is it other data?
Cause what i want is the data I added here and somehow visualise it in the chart/graph.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks