Hello!
I need to plot in Excel 2007 something which looks like this:
Box Whisker Plot.jpg
Basically I want to plot 2 box whisker plots, then have some empty space and then again 2 box whisker plots, followed by empty space and another 2 box whisker diagrams.
Also I want to have 3 red lines going to each of the box whisker pair, where the position is defined on different values.
I would be very thankful for any assistance. A dummy file with this structure would be great!
Regards,
Excelactuary
Hi,
try to play with this ... http://www.dummies.com/how-to/conten...for-excel.html ... I've done once similar to your picture, but without gaps ... to stacked column chart I've just added line chart on second axe ... but like I sad ... without a gaps.
At the moment I'm not able to test, so just sending a link where I've found solution to similar problem ...
Cheers, Marko
IF a = b THEN
GO "back to school"
Do you know a way to implement the gaps?
Fast solution is to use gaps in the table ...
Three_pairs_of_box_whisker_plots_in_one_coordinate_system.jpg
Cheers, Marko
please help me out for pair trading on stocks,commodities,currencies on excel sheets
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks