Notices
Results 1 to 10 of 10

Thread: Please Recommend a Proper Charting Software

  1. #1 Please Recommend a Proper Charting Software 
    Forum Freshman
    Join Date
    Jul 2009
    Posts
    7
    Hello Friends!

    I am somewhat new to scientific charting) more accustomed to working in Excel, but I think I have run into its limitation as regards to charting…I am not sure if it can do the following…

    I wanted to ask if there is charting software that can do these tasks:

    1) Take the time series data from excel, each data series will have two describers – COLOUR and THICKNESS
    2) plots each time series data in such a way as:
    a) colors the time series according to a time series criterion (eg. 1 for red, 2 for black)
    b) allows to adjust the thinness of the plotted series based on another criterion (e.g. 10 very thick, 2- close to hairline)

    Thanks for your time!).
    I will be glad to hear any onion.

    Dima


    Reply With Quote  
     

  2.  
     

  3. #2  
    Moderator Moderator
    Join Date
    Apr 2007
    Location
    Washington State
    Posts
    8,309
    I don't think there is a way to get excel to do conditional formatting for a plotted series other than write a macro.

    As a substitute though, you could create series based on your conditions such that for example they might plot to y=0 when they don't apply to mask them, but look like a normal plot on the graph when they do. It's not every elegant I admit.


    Meteorologist/Naturalist & Retired Soldier
    “The Holy Land is everywhere” Black Elk
    Reply With Quote  
     

  4. #3  
    Forum Freshman
    Join Date
    Jul 2009
    Posts
    7
    thanks! I am looking for a way to do some nice looking charts out of these series - I guess excel just is not made for that!))) I wonder if for example Matlab or any other package can do this task....what do you think?
    Reply With Quote  
     

  5. #4  
    Forum Professor wallaby's Avatar
    Join Date
    Jul 2005
    Location
    Australia
    Posts
    1,521
    Quote Originally Posted by dima777 View Post
    I wonder if for example Matlab or any other package can do this task
    Not automatically, but you can set the colour, line thickness, line type, axis labels, legend, etc. without too much difficulty. I think you can even use a plot editing tool if you don't want to have to type out the commands.
    Reply With Quote  
     

  6. #5  
    Forum Freshman
    Join Date
    Jul 2009
    Posts
    7
    Quote Originally Posted by wallaby View Post
    Quote Originally Posted by dima777 View Post
    I wonder if for example Matlab or any other package can do this task
    Not automatically, but you can set the colour, line thickness, line type, axis labels, legend, etc. without too much difficulty. I think you can even use a plot editing tool if you don't want to have to type out the commands.
    Thanks! you mean there is no way to buld an automated routine to assign line thickness based on preset criterion in Matlab? If no - I wonder if there is a software capable of this?
    Thanks!!)
    Reply With Quote  
     

  7. #6  
    Forum Professor wallaby's Avatar
    Join Date
    Jul 2005
    Location
    Australia
    Posts
    1,521
    Quote Originally Posted by dima777 View Post
    Thanks! you mean there is no way to buld an automated routine to assign line thickness based on preset criterion in Matlab? If no - I wonder if there is a software capable of this?
    Thanks!!)
    I wouldn't say no way, but you'd have to write a script that does that yourself so it would depend on your proficiency with writing matlab code. To my knowledge there are no built in functions that allow you to do this.
    Reply With Quote  
     

  8. #7  
    Forum Freshman
    Join Date
    Sep 2011
    Posts
    14
    It sounds to me that what you want is something like a table in PowerPoint. You're able to take the data-set and automatically create a graph with it... perhaps I'm off though.
    Reply With Quote  
     

  9. #8  
    Forum Freshman
    Join Date
    Jul 2009
    Posts
    7
    Quote Originally Posted by wallaby View Post
    Quote Originally Posted by dima777 View Post
    Thanks! you mean there is no way to buld an automated routine to assign line thickness based on preset criterion in Matlab? If no - I wonder if there is a software capable of this?
    Thanks!!)
    I wouldn't say no way, but you'd have to write a script that does that yourself so it would depend on your proficiency with writing matlab code. To my knowledge there are no built in functions that allow you to do this.
    Thanks for your reply...Can you pleas recommend a big Matlab developer forum where I can ask further???)
    Reply With Quote  
     

  10. #9  
    Forum Freshman
    Join Date
    Jul 2009
    Posts
    7
    Quote Originally Posted by Reprise View Post
    It sounds to me that what you want is something like a table in PowerPoint. You're able to take the data-set and automatically create a graph with it... perhaps I'm off though.
    Well I want to create a chart with time series data that is plotted according to a few criteria assigned to each data series)
    Reply With Quote  
     

  11. #10  
    Forum Sophomore
    Join Date
    Jan 2008
    Location
    Texas
    Posts
    158
    You could do this in Excel but you would have to write the code in VBA.

    Is each graph going to have the same color criterion? (graph 1 red) (graph 2 blue, etc?) are you plotting more than one experiment on each graph?
    Reply With Quote  
     

Similar Threads

  1. Which tool would you recommend?
    By VnnE4aEXxfhkrjPX in forum Environmental Issues
    Replies: 0
    Last Post: July 14th, 2011, 12:45 AM
  2. Recommend me some AI books!
    By m84uily in forum Computer Science
    Replies: 0
    Last Post: December 1st, 2010, 11:34 AM
  3. Recommend some undergrad textbooks
    By em12 in forum Mathematics
    Replies: 1
    Last Post: July 22nd, 2009, 05:47 PM
  4. The proper fear of God
    By mitchellmckain in forum Scientific Study of Religion
    Replies: 57
    Last Post: April 22nd, 2009, 06:17 PM
  5. Lgr5 - a proper stem cell marker?
    By spuriousmonkey in forum Biology
    Replies: 3
    Last Post: November 2nd, 2007, 08:54 AM
Bookmarks
Bookmarks
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •