RSS

Moving Bar chart in MS Excel

18 Apr

It’s very important to learn some simple tricks to go on the way of preparing “DASHBOARD”. Here we’ll learn one part of the dashboard.

The circled part is what we’ll learn here. Let’s say you want to show 50% of some target as completed. Here is how it works.

1> Create a bar chart by taking any number between 0 to 100. It looks as below image.

2> Go to format Axis and change the min, (0) max (100), Major unit and minor unit as below image.

3> “Delete” both the axis.

4> Format Chart Area.  Make fill color to “no color” and Border color to “no color”.

5> Insert New Shape, just little bigger than the graph.

6> Send the shape behind the graph. It’ll look like the below image.

7> Connect the cell marked (50) as per your requirement and see the changes on graph.

Note: restrict the cell value from 0 to 100 by “data validation”.

Hope this helped you. Thanks

Advertisements
 
Leave a comment

Posted by on April 18, 2012 in MS Excel, My Home

 

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: