There was considerable interest among ActiveRain members in my previous posts, How to copy an Excel chart to an image file and Advanced formatting to dress up Excel charts. Is there interest in a post on how to create a chart which can be changed "on the fly" merely by clicking your mouse button once to drag and drop an item to a new location? If so, I'll post that in the near future. I've shown an example below of how a chart can be changed by this method. Once the baseline chart is created, only one click-drag-drop step is required to turn that chart into a totally new one. The Microsoft name for this kind of chart scares some people so I just call them "Drag & Drop" Charts.
Using drag and drop, you can go from this...
...to this. And do it in only 1 step using only your mouse
Please give me some feedback so I will know whether there is interest in this. If so, I will post in in the near future.
Visit www.KauaiRocks.com for Hawaii real estate information