- IT help – excel results displayed graphically?
I’ve got a little simulation spreadsheet thing, to show how a number of variables can interact with each other and ultimately affect two results. In the middle of all the equations is a step that splits a total into 3 percentages.
What I’m after is a way to graphically represent these %ages just to give a visual pointer as to what is going on. I *could* use one of those combined bar chart things, but I was hoping I could get something that looks a bit more polished.
Amy ideas either how to achieve this in excel, or what other program I could import my excel figures into?Posted 4 years ago
Aye, stacked histogram is the bog-standard Excel method. I was after something a bit more… engaging.
I’m trying to end up with a display like the following:
The %ages I’m calculating are a water layer, an oil layer and an intermediate emulsion layer, each as a percentage of the whole (not really bothered about gas for now). I’d like to be able to output a graphic like the above that alters the levels according to the % calculated.
Any ideas?Posted 4 years ago
I think for my level of IT prowess, robbo‘s sugestion is the one that will cause me least headache, as I’m failing miserably to make the stacked histogram thing do what I want – it’s displaying the three %ages as 3 separate bars… 😕
I shall peruse the contextures site as well today, instead of doing any actual work.Posted 4 years ago
The topic ‘IT help – excel results displayed graphically?’ is closed to new replies.