0

Microsoft Excel mixes formating, presentation and data, that drives me crazy. I just can't use my poor data this way.

Is there a tool which works with data and tunes its reporting separately?

I can use Python with ML libraries or something, but prefer some user-friendly graphical application. Do you know one?

  • Why can't you enter your data on one worksheet and create your charts on another? You can reference cells and ranges on other worksheets (or even workbooks). – Mick Mar 18 '17 at 17:02
  • Because it is a hack. – uhbif19 Mar 21 '17 at 21:13
1

There is a python based spreadsheet pyspread that is able to use python code directly in each cell, in fact each cell can contain a complete python program, that you might like to take a look at.

enter image description here

But I would also strongly suggest taking a look at Jupyter notebooks. They will let you obtain, store, manipulate, evaluate and present your data in a lot of ways. Take a look at some of the entries in "A Gallery of interesting Jupyter Notebooks" and give you a variety of methods to present your working and results.

enter image description here

All of the above software is:

  • Free, Gratis & Open Source
  • Cross Platform
  • Widely Used
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.