Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
Using Matlab or Simulink to produce an 'active' Chart from Excel Data

Subject: Using Matlab or Simulink to produce an 'active' Chart from Excel Data

From: Jason Reid

Date: 12 Mar, 2013 16:04:07

Message: 1 of 2

Hi everyone,

I have four sets of data in Microsoft Excel that I would like to plot on a Bar Chart or similar to provide a means of comparison. However I have 719 columns of this data. What I would like to do is to have an 'active' Bar Chart which cycles through the 719 columns of the four sets of data.

My thoughts are that I should be able to find software that will enable me to produce a Bar Chart that is capable of being set up to cycle through the data and thus provide an 'active' Chart.

Is there a way of using Matlab or Simulink to do this?, or is there an alternative software you suggest that would be better suited?

I hope this makes sense if not please let me know and I will try to clarify, any help with this would be much appreciated.

Many Thanks,

Jason

Subject: Using Matlab or Simulink to produce an 'active' Chart from Excel Data

From: Ryan

Date: 23 Mar, 2013 21:43:06

Message: 2 of 2

"Jason Reid" <k1004567@kingston.ac.uk> wrote in message <khnjlm$oro$1@newscl01ah.mathworks.com>...
> Hi everyone,
>
> I have four sets of data in Microsoft Excel that I would like to plot on a Bar Chart or similar to provide a means of comparison. However I have 719 columns of this data. What I would like to do is to have an 'active' Bar Chart which cycles through the 719 columns of the four sets of data.
>
> My thoughts are that I should be able to find software that will enable me to produce a Bar Chart that is capable of being set up to cycle through the data and thus provide an 'active' Chart.
>
> Is there a way of using Matlab or Simulink to do this?, or is there an alternative software you suggest that would be better suited?
>
> I hope this makes sense if not please let me know and I will try to clarify, any help with this would be much appreciated.
>
> Many Thanks,
>
> Jason

I think the first thing to do would be to import the data into Matlab, from Excel. right here, here are several options to do just that:
http://www.mathworks.com/help/matlab/ref/xlsread.html

Also, see this:
http://blogs.mathworks.com/pick/2007/08/13/video-series-reading-excel-data-into-matlab-with-a-gui/

That should help you with the Excel stuff, as well as the plotting stuff.

Tags for this Thread

No tags are associated with this thread.

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us