Home > SQL / BI > Manipulating Excel Charts Directly

Manipulating Excel Charts Directly

Excel 2007 provides some great charting functionality (and Excel 2010 even more so), but one thing that often crops up is a request to be able to do a sort of ‘graphical goal seek’ – manipulating a point on the graph that updates the cellular values it is based on. Enter the snappily-named Excel Add-in for Manipulating Points on Charts. It gives you a dialog box that allows you to select a point on a chart and play with the value directly:

image_21[1]

Pretty cool!

Advertisements
Categories: SQL / BI
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: