How to make plot change as I move the slider? How to import these values from excel file?

I would like to make an app that will allow me to plot some values from an excel sheet and as I move the slider it will keep changing. So, if I have an X value of 1 and a Y value of 2 at slider time 1 I want to show that and if I have an X value of 2 and Y value of 3 at slider time 2 then I want to show that at that given time.

classdef app1 < matlab.apps.AppBase

% Properties that correspond to app components

properties (Access = public)

UIFigure matlab.ui.Figure

forcegraph matlab.ui.control.UIAxes

Importgraphvalues matlab.ui.control.Button

TimeSliderLabel matlab.ui.control.Label

TimeSlider matlab.ui.control.Slider

end

methods (Access = private)

% Value changed function: TimeSlider

function TimeSliderValueChanged(app, event)

end

end

% App initialization and construction

methods (Access = private)

% Create UIFigure and components

function createComponents(app)

% Create UIFigure

app.UIFigure = uifigure;

app.UIFigure.Position = [100 100 640 480];

app.UIFigure.Name = 'UI Figure';

% Create forcegraph

app.forcegraph = uiaxes(app.UIFigure);

title(app.forcegraph, 'Force vs Cars')

xlabel(app.forcegraph, 'Cars')

ylabel(app.forcegraph, 'Force')

app.forcegraph.Position = [2 108 640 373];

% Create Importgraphvalues

app.Importgraphvalues = uibutton(app.UIFigure, 'push');

app.Importgraphvalues.Position = [261 12 122 22];

app.Importgraphvalues.Text = 'Import graph values';

% Create TimeSliderLabel

app.TimeSliderLabel = uilabel(app.UIFigure);

app.TimeSliderLabel.HorizontalAlignment = 'right';

app.TimeSliderLabel.Position = [1 81 32 15];

app.TimeSliderLabel.Text = 'Time';

% Create TimeSlider

app.TimeSlider = uislider(app.UIFigure);

app.TimeSlider.Limits = [0 2000];

app.TimeSlider.MajorTicks = [0 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000];

app.TimeSlider.ValueChangedFcn = createCallbackFcn(app, @TimeSliderValueChanged, true);

app.TimeSlider.Position = [53.6875 87 568 3];

end

end

methods (Access = public)

% Construct app

function app = app1

% Create and configure components

createComponents(app)

% Register the app with App Designer

registerApp(app, app.UIFigure)

if nargout == 0

clear app

end

end

% Code that executes before app deletion

function delete(app)

% Delete UIFigure when app is deleted

delete(app.UIFigure)

end

end

end

[Kevin Holly]

Do you have a sample of what the Excel sheet looks like?

[Eduardo Reyes]

I am attaching it

[Kavinprasad M]

How to get the changed slider data from plot back to table?

Answer 1

[Kevin Holly]

Please see the app attached.

[Eduardo Reyes]

Awesome! Thank you.

Another quick question, how can I make the plot change as I drag the slider button without having to let go the click? Insted of holding and let it go where I want

thanks

[Kevin Holly]

See app attached.

% Value changing function: TimesSlider
        function TimesSliderValueChanging(app, event)
            app.TimesSlider.Value = round(event.Value);
            app.TimeEditField.Value = round(event.Value);

            % Plot
            plot(app.UIAxes,app.Data(app.TimesSlider.Value,:))  
        end

[Eduardo Reyes]

I tried using that one but is asking be to load the file everytime I drag the slider just a bit

[Kevin Holly]

Did the app I attached work for you?

Make sure the loading file code is in the correct callback.

[Eduardo Reyes]

the first one worked but is not updating as I drag until I let go the click. The second one is not working because is asking me to upload the file everytime I tried dragging the slider

[Kevin Holly]

I cannot replicate the issue. It works fine for me.

[Eduardo Reyes]

It's working!

Thank you so much!!!