Hello,
I am trying to do plot data in Excel where I will place a symbol on the graph and the symbol width will be like a box plot in the horizontal direction and the height will be like a box plot in the vertical direction.
Each symbol will apply to an individual data set. So the graph would have say 5 “rectangular” symbols where the height and width of the rectangle are set like a box plot. (Meaning I can setup cells that subtract and are hidden accordingly to set where these symbols are placed.)
Does anybody have any suggestions? I could do the vertical portion with stacked bars and box plot procedure and likewise with a horizontal staked bars but I want to combine this and have one symbol dropped in.
Make sense?
Thanks
Sparky_
I am trying to do plot data in Excel where I will place a symbol on the graph and the symbol width will be like a box plot in the horizontal direction and the height will be like a box plot in the vertical direction.
Each symbol will apply to an individual data set. So the graph would have say 5 “rectangular” symbols where the height and width of the rectangle are set like a box plot. (Meaning I can setup cells that subtract and are hidden accordingly to set where these symbols are placed.)
Does anybody have any suggestions? I could do the vertical portion with stacked bars and box plot procedure and likewise with a horizontal staked bars but I want to combine this and have one symbol dropped in.
Make sense?
Thanks
Sparky_