Hi



I have a spreadsheet with a small table and a horisontal bar graph connected to it, see attachment. As you can see I have 5 bars that have different lengths. I don't know what configures the length, but I would like to be able to lock all bars to the same length, regardless of the numbers it represents. I use this as statusbars to see how far work has come. Left column shows what has been done, middle coloumn shows whats left to do, all for different departments. (Right coloumn is not connected to the graph).

I have tried alot of different settings but can't figure out how to (if possible at all) make all bars always have the same length. Anyone?

Thx in advance
Kjetil


graph.jpg

Can you use something like the attached?

Attached Files

BarChart.xlsx (136.3 KB, 9 views)

Yes, that will work. Figured it out myself too, probably did something wrong the first time. Good to know that I am still able to learn...