Click here to Skip to main content
Click here to Skip to main content

Excel data file visualizer

, 29 Aug 2013
Rate this:
Please Sign up or sign in to vote.
Excel data files are used everywhere. It will be convenient to visualize the data more intuitively with touch UI

Please note

This article is an entry in our AppInnovation Contest. Articles in this sub-section are not required to be full articles so care should be taken when voting.

Introduction

Excel data files are used for data analysis in many fields. People frequently share their analysis results with excel data files. Microsoft Excel is powerful to provide so many features. But it misses some intuitive visualization features that people would like to have on the tablet to provide easy exploration. 

Some features like:

  1. Choose any one column, plot the line of the column, which is available in plotting function of Excel;
  2. Use normal touch based zoom-in/zoom-out to visual any range of the data, which is not available in Excel;
  3. Set the threshold of outliers to crop the outliers to specified value so that the overall trend is not affected by a few really large outliers, which is not available in Excel; 
  4. Add additional columns for more lines, all lines should be synchronized with the same scale;
  5. Each line can be horizontally shifted by a specified offset by dragging left/right to check the alignment of different columns, which is useful in some scientific data analysis, which is not available in Excel. 

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Member 10183606
Software Developer (Senior) SRI
United States United States
No Biography provided

Comments and Discussions

 
AdminThanks for your submission, but you need some additional info PinstaffKevin Priddle30-Aug-13 9:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 29 Aug 2013
Article Copyright 2013 by Member 10183606
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid