how to create legend from neighboring column in 3d plot
Show older comments
Hi, I have a question, I'm wondering how I'd be able to create a legend based on a neighboring column
right now I have this code
And the pulled table doesn't necessarily extract the element names (i assume because it's not integer?)
but I'm wondering how I can make my scatter legend based on my column 1 in the excel sheet?
7 Comments
Image Analyst
on 28 Apr 2023
How many legend labels would you want, and what do you want them to say? Do you want one legend label string for every unique marker color?
Andrew
on 28 Apr 2023
Image Analyst
on 28 Apr 2023
OK, you want as many legend strings as points that are currently selected in your Excel instance. Some questions remain:
- So are you using ActiveX to figure out which cells in Excel are the currently selected cells? If not, how do you know which ones (cells, indexes) are selected?
- Where exactly does the legend label string come from (unanswered question from before)? Is it some column in the workbook and you want to use the strings in the same rows as the rows you selected?
I'm going to be busy traveling this weekend and might not be able to answer if you don't answer quickly.
Andrew
on 28 Apr 2023
Image Analyst
on 28 Apr 2023
OK, but his code does not determine how many cells you selected. Remember you said "depend on the index that I selected".
Andrew
on 28 Apr 2023
dpb
on 28 Apr 2023
"...but his code does not determine how many cells you selected..."
Au contraire, good buddy! <VBG> I did get that far before the phone rang...it's in
C=jet(nnz(ix));
although not at that point a separate variable...not sure if going to need that or not, yet, but is good possibility.
Will return to the field of battle; may need to look more at the structure of the spreadsheet; I didn't look at it specifically, to know what details may look like...
Accepted Answer
Why folks continue to beat head against wall with deprecated xlsread is beyond ken...
fn='https://www.mathworks.com/matlabcentral/answers/uploaded_files/1369019/PIP2.xlsx';
opt=detectImportOptions(fn,'ReadVariableNames',1,'VariableNamesRange','A1','DataRange','A2');
opt.SelectedVariableNames=opt.VariableNames(~startsWith(opt.VariableNames,'Var'));
tT=readtable(fn,opt);
head(tT)
There's something really funky about the content of this spreadsheet that dreadfully screws up the MATLAB detection process in trying to find out where the data are and creating an appropriate internal import object.
Without all the help given above, it can't figure out the first row are variable names and that the real data begins in the second row -- it skips down to row 7 -- I've noticed in the past that having some odds 'n ends over to the side out of the way of the main data can confuse things; it seems to have done so royally here.
I'd be tempted to suggest this one be sent to TMW as a sample that their 'bot ought to do a much better job on and as a template to figure out what caused it to lose its way so badly....that's a sidelight; it should NOT be that much grief to read the table -- generally detectimportOptions does do a pretty good job; but "not so much!" on this one. That's frustrating to the newcomer who doesn't yet know about all the innards that one can play with...
Anyways, now on to the problem at hand...
ix=(tT.AtomicNumber>=21)&(tT.AtomicNumber<=30);
hSc3=scatter3(tT.CED(ix),tT.R(ix),tT.E0(ix),'o','filled');
NNZ=nnz(ix);
C=jet(NNZ);
hSc3.CData=C;
xlabel(tT.Properties.VariableNames(5))
ylabel(tT.Properties.VariableNames(4))
zlabel(tT.Properties.VariableNames(3))
OK, now we're back to where was before got so rudely interrupted before, but with the actual full table and names...
scatter3 handle hSc3 is still just one object; so now we'll fix things up to be able to make a legend object to match. This again is a pretty common "hack" one has to do with handle graphics when the base objects don't match what one really wants to do...
%tT(ix,:)
hold on % don't let added stuff wipe out what we've already got drawn
hL=plot(nan(2,NNZ),'o'); % create an array of NNZ columns to force NNZ line handles
set(hL,{'MarkerFaceColor'},num2cell(C,2),{'MarkerEdgeColor'},num2cell(C,2)) % force the same color map
hLg=legend(hL,tT.Element(ix)); % and add the legend on those
8 Comments
Andrew
on 28 Apr 2023
Sorry, I'm not super familiar with coding and was just trying to find something that works well. I was trying other stuffs as well like readtable here, but the problem that I encountered is it removed a lot of the first column from the extracted table (13-22) is gone for some reason
This one looks more robust and easier to work with though
Andrew
on 28 Apr 2023
Andrew
on 29 Apr 2023
dpb
on 29 Apr 2023
I got interrupted again, before adding some additional comments/amplifications, sorry...
The key thing is that, unfortunately, TMW didn't think ahead in the design of the scatter class objects to provide an array of handles nor in legend if going that route on some of the plotting routines to allow it to hold more than just what is associated with the axes to allow for such customizations. It's just not very flexible; it does what it does nicely, but it's hard sometimes to get the effects wanted...
Anyways, the key feature is that plot and friends, creates the HG2 graphics objects when passed NaN as plotting values, but it quietly ignores them on rendering the plot; hence you can create additional graphics objects on an axes without them being visible precisely for such purposes as this. Sneaky and not intuitive, but it's what one does with HG2. "When in Rome..."
Another "feature" used here is that HG2 draws a single line for a vector which returns a single handle -- so if we were to try to use just NNZ points, we'd be stuck with the same problem we had with the scatter -- only one line handle; and it can't have but one color, regardless however many points there might be; they didn't provide a color array for a line object.
BUT, if you plot a matrix; the vectorized behavior of plot, like most MATLAB builtin functions, is to operate by column -- so, plotting an array of NNZ columns with at least two rows draws NNZ lines; exactly what we needed to label in the legend. Then, it's just setting the properties to match; the 'o' marker for a line isn't filled by default and there isn't a high-level 'filled' meta-property, so have to specifically set the face and edge colors. The set() syntax is one of general use to set multiple handle objects at one time; use a cell array to contain the 'Property' and value pairs; the num2cell is to turn the 2D array into a 10x1 cell array each containing the color RGB three-vector; set passes each cell member in turn to the associate member in the handle array.
As is often the case, the end amount of code required is pretty small and concise; it may take quite a long time fiddling around to get to the desired end result, however. It comes only with experience and time; it really is not something an apprenctice will figure out on their own without having seen the concept demonstrated somewhere first...
Andrew
on 29 Apr 2023
dpb
on 29 Apr 2023
NNZ=nnz(ix);
It's the count of nonzero elements in the lookup vector; ergo, the number of lines needed to add to label in the legend to match the plotted number of points/elements selected.
BTW, the compound logic expression is one for which I've written a small utility function for to put the clutter out of the toplevel code...
function flg=iswithin(x,lo,hi)
% returns T for values within range of input
% SYNTAX:
% [log] = iswithin(x,lo,hi)
% returns T for x between lo and hi values, inclusive
flg= (x>=lo) & (x<=hi);
end
Then one can write
ix=iswithin(tT.AtomicNumber,21,30);
instead of
ix=(tT.AtomicNumber>=21)&(tT.AtomicNumber<=30);
Andrew
on 29 Apr 2023
"...what do I need to do If I want to select at# 21-23,49-52 and 82-83 at the same time?"
The higher level comes in very handy there to reduce clutter...
ix=iswithin(tT.AtomicNumber,21,30)|iswithin(tT.AtomicNumber,49,52)|iswithin(tT.AtomicNumber,82,83);
Nota Bene the "or" operator, not "and". And, of course, you shouldn't write such code burying "magic numbers" inside the code itself, but use a set of low/high range arrays and set those instead. Then you can prompt the user for values desired and not change the code at all. Separate the logic from the data.
The problem with the above solution, however, is that it requires explicit code for the number of disparate selections. That's awfully inconvenient to code around; that solution works well only if the number of groups to be selected from is known a priori and doesn't change.
Alternatively, for disparate sets such as this, you can use some of the other MATLAB set operation functions or ismember
R=[21,30; 49,52; 82,83]; % set ranges desired in array by row, start-stop
rnge=cell2mat(arrayfun(@(i1,i2)i1:i2,R(:,1),R(:,2),'uni',0).'); % convert to a list of wanted values
ix=ismember(tT.AtomicNumber,rnge); % look 'em up in your table.
More Answers (0)
Categories
Find more on Creating, Deleting, and Querying Graphics Objects in Help Center and File Exchange
