Simple (?) charting question

[Copernicus]

Brain dead this morning!

I want to create a chart that is a series of horizontal bars. The axis label is years. Each bar changes color from Green to Yellow to Red in a specified year based on data in a table. I tried a table with years across the top and data values of 1, 2, 3 in rows, with data for each scenario in rows. I also tried transposing to columns. I cant find a bar chart format that works for either table.

Thanks!

 

[dave3009]

Perhaps

So we got to the bit where we plotted the sum of numbers 1, 2 & 3. We also need to plot in cells before them the value of 2016. So the top row you plot values 2016, 6, 3 & 14. The chart type is a stacked bar chart and at first the data most likely won't start where you want. Right click the axis and select Format Axis | Minimum -> Fixed -> 2016 | Maximum -> Fixed -> 2038 | Major Units -> Fixed -> 1. You can tinker about with the size of the font and the angle etc to suit your needs. Then you can set the desired bar colour to your green, yellow & red format instead of the default colours I've used.

Let me know how you get on, I'm watching a decent film on television so will be around for a good while yet if you need further help

Dave

 

[Copernicus]

Im not sure how to plot the 2016 as a value. When I add the horizontal axis and the default values are entered, it is okay. When I change the min/max the bars disappear.

 

[Copernicus]

sorry...the data changed a bit if that was confusing!

 

[Copernicus]

Here I plotted the 2016 an additional range and set the min/max. The bars go crazy lol.

 

[Copernicus]

Success! though I dont know why. I switched columns in the data range menu, then switched them back, and voila!

Thanks for all your help, and enjoy the movie!