Hawaii Real Estate Resource

head_left_image

Excel "Drag & Drop" Charts (Microsoft calls them "Pivot Charts")

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.

Mahalo (thanks),

Richard

Visit www.KauaiRocks.com for Hawaii real estate information

Richard Dolbeare, REALTOR-ASSOCIATE

Richard Dolbeare
REALTOR-ASSOCIATE®
Accredited Buyer Representative & e-PRO
Century 21 All Islands, the #1 brokerage on Kauai
(808) 651-4550
(866) 757-8239 (FAX)

Richard T. Dolbeare, R(B) photo

 

Richard T. Dolbeare, R(B)

Keller Williams Realty(808) 651-4550

Aloha@RichardDolbeare.com 

www.MauiSandCastles.com and www.KauaiRocks.com 

 Hawaii multi-island specialist, Maui & Kauai
Richard Dolbeare eBusiness Card

Google+ Twitter icon Facebook logo Youtube logo

Comment balloon 9 commentsRichard T. Dolbeare • June 25 2007 12:30PM

Comments

I for one would certainly be intereted in this method as I had to use photo shop to turn my chart into a .jpg file.  Thank you.

Posted by Lisa Spruck (Monarch Business Solutions, Inc) almost 12 years ago

Hi Lisa,

Excel allows you to copy a chart directly to a jpg file from the Excel menus, no need for Photo Shop.  See my referenced post on that topic. 

I'm currently looking to see if there is interest in changing a chart on the fly by dragging & dropping.

Aloha,

Richard

Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) almost 12 years ago
Great Post.
Posted by Frank Rubi, FrankRubiRealEstate.com (Frank Rubi Real Estate, LLC) almost 12 years ago
OK, few comments so I won't go there.  If you have read my previous posts, you probably know I love using the advanced features of Excel and it's fun to share.
Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) almost 12 years ago
YES YES YES YES YES YES YES...PLEASE!  Thank you!
Posted by Marlene Bridges, Laguna Homes|Laguna Condos|Laguna Real Estate (Village Real Estate Services, Inc.) almost 12 years ago
I like this blog post too Richard.   You're doing some good work here.  Nice formatted post.  Easy to read.
Posted by Scott Hoag, Preferred Lender / Mortgage Company (FBC Mortgage) almost 12 years ago
Thanks for the feedback Scott.
Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) almost 12 years ago
Richard my friend... thank you for making it all sound so easy!
Posted by Vanessa Schwartzel (Turtle Cove Realty) almost 12 years ago

Ah, friends are important and I value being on your list.  Thank you.  As for the Drag & Drop chart, it IS quick & easy once you learn how.  Actually, it's easier than a standard chart.  Stop by for a hands-on demo sometime, it's fun and pretty awesome!

Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) almost 12 years ago

This blog does not allow anonymous comments