This is a very short post. I just wanted to say what I'm reading now.
I'm reading a book right now, Good Charts by Scott Berinato. It's a beautiful book that discusses the theory of what makes a good chart and how to go about making good charts. I'm in the section talking about the ethics of deceiving charts. I already have an idea of a chart to try to make for a current project, but I don't think Microsoft Excel can do it. I'm going to have to play around. Page 92 of the soft back book lists some software tools available for dataviz.
The book is not a detailed how-to such as you would find in books about charting using Excel. It's more conceptual and theoretical to give you the underpinnings of what makes a good chart rather then a step by step recipe because if you really want to know how to create beautiful, clear and meaningful charts, you have to know about aesthetics and design rather than the specific cookbook. You will go further if you know the concepts.
That's all I have to say about the book other than it's really beautiful.