Ask a new question

vertical data bar

Hello there,

I'm trying to have a visual filling scenario on the spreadsheet. I have formated (merged and resized) several cells  so that they represent a liquid holding tank. I found that data bar in conditional formatting is an excellent visual for the liquid level in a tank when amounts change but the only thing is its changing horiazontally.whereas in my case I want it to change vertically (basicly go up and down as liquid level in a tank changes

does anyone have a solution how to change the orientation of a databar?

thanks for any help in advance

KK

The best way to have your data bar look vertical is by taking a copy of the range, and paste as picture link, and then rotate the picture 90 degrees to the left.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

This page has some examples you can download: http://chandoo.org/wp/2011/04/13/how-to-make-a-5-star-chart/
Search more at this site, they have LOTS of good tips for "unusual" techniques

How to create a thermometer graph in Excel

http://www.techrepublic.com/blog/msoffice/how-to-create-a-thermometer-graph-in-excel/6195?tag=nl.e056



 QUICK AND EASY EXCEL CHARTS – Collection of Charting Tips

http://j-walk.com/ss/excel/usertips/charttips.htm         A collection of charting tips

    *  Creating combination charts

    * Creating a transparent chart series

    * Rotating text with an AutoShape

    * Saving a chart as a GIF file

    * Layouts for column charts

    * Display multiple charts on a single Chart sheet

    * Unlink a chart series from its data range

    * Format cells to display in thousands

    * Handle missing data in a line chart

    * Displaying a value in an AutoShape

    * Creating a thermometer style chart

    * Creating a linked picture of a range

    * Add graphics to your page header

    * Creating a non-graphic chart directly in a range

    * Update charts automatically when you enter new data





.
*****
.
As computer scientists we are trained to communicate with the dumbest things in the world – computers –
so you’d think we’d be able to communicate quite well with people.
Prof. Doug Fisher

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

hello again all.

First of all:thanks to all of you for your replies:

Please see the file on the link. the minimum value is 0 maximum is 10000. I dont necesserily want to go by the charts since its going to a lot of them  but if they are small in size and easy to see for all 10 cells that would be fine.

http://www.mediafire.com/?hvi4egca8abjww0

It would've been so convenient of excel had an option to change data bar direction/orioentation.

All I want is,to make the "filling" (or , as in this case data bar) go up and down instead of left and rigtht.

Thanks for all your help again.

regards,

KK

 

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 7, 2025 Views 2,140 Applies to: