Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
I need to plot 3 variables on a scatter plot diagram for a report I create. I have been doing this manually since I started because I dont know how to automate the process.
the 3 variables are
asset class: equity, credit, rates, commodity, fx, hybrid (which I can use as the y-axis)
Maturity(years) : <1,1,2,3,4,5,6,7,89,10+ (which I can use as the x-axis)
Region: a,b,c,d,e,f,g,h (which I can use as the different series)
if there is more than 1 product for the same country, asset class and maturity, I don't want the plot points to stack up because I cant see that there is more than 1 product. Every time I try this the scatter looks horrible and the axes dont make sense. Please help thanks.
If there is more info I can provide for a better answer please let me know. I can upload an image of something I created manually that I would like to mimic but I can only type urls and not upload files I believe.
thank you,
Kurt Oriol Read More