Chai Posted September 18 Share Posted September 18 Hi, Im trying to replicate excel's ability to create a scatter plot consisting of multiple Y and X axes of the same type in spotfire. (refer snap shot below) In spotfire, I've macthed the column 'Date' when I merged them into one table. How do I achieve that? Appreciate any advice anyone may have. Link to comment Share on other sites More sharing options...
Solution David Boot-Olazabal Posted September 18 Solution Share Posted September 18 Hi Chai, You can resolve this by adding the sets as Rows, instead of columns. The end result will look like this: Your data canvas set up looks like this, with the first combination of tables (Set A + Set B) as example. Make sure you join on all the columns, so the X and Y values are 'falling' in the same column: I've also added the example dxp file, but it's in version 14.4, so not sure if you can open that properly (depending on your version of Spotfire). Kind regards, David ScatterPlot.dxp Link to comment Share on other sites More sharing options...
Chai Posted September 19 Author Share Posted September 19 Hi David, thanks! that worked wonderfully. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now