About the author

Image of Philipp Kowalski

Philipp Kowalski is a self-taught Excel-lover, project manager and blog-owner. Besides developing "beautiful" solutions in MS' premier spreadsheet tool, he loves his fiance, his cats and surfing the net. He is CEO and owner of Inservo IT, the company behind Excel-King. He's also available on Twitter and YouTube. If you like this website, please leave a comment. If you want to know more visit the forums or look into the about section of this website.

Error
  • Error loading Modules:
Today I want to share a quick tip with you which I learned recently. I think you know the problem: Sometimes it is hard to give a nicely created chart an exact position. You can of course CTRL-klick your chart to treat it like a graphic and nudge it with your arrow keys (see this post) but there is an even easier way.

Let's assume that you have created this nice little column chart:

This is our starting situation

Now, if we want to align this to the grey area right of the data table there is an easy way to do it: Simply hold down the ALT key on your keyboard (should be the OPTION key if you are using a Mac) and drag the corners of the chart to the corresponding borders of the grey area. Hover over the little dots on each of the charts for borders until the cursor changes to the double ended arrow. The borders of the chart will now "snap" to each cell border. By the way: For the very small chart I wanted to produce, I decided to get rid of the charts title. The final result looks like this:

Hope this helps. If you like this post, please feel free to post a comment.

Discuss this blog post in the forums (click the blue button)


Administrator
Written on Thursday, 14 January 2010 22:58 by Administrator

Viewed 2030 times so far.
Like this? Tweet it to your followers!

Rate this article

(0 votes)

Add comment


Security code
Refresh

Sharing is caring

Facebook Twitter Digg Delicious Stumbleupon Google Bookmarks RSS Feed 

Tweet, Tweet...

Click the little blue friend to follow Phil on Twitter!

Advertisement

Create Excel dashboards quickly with Plug-N-Play reports.