columnwidths.xls

Coloured Variable Width ColumnsXYTopDownUpScaleLabel X%ShareCost()01501500Gas20%150.0020.00%15020.00%150-37.510.00%Electricity15%112.5035.00%112.515.00%112.5-22.527.50%Water12%90.0047.00%9012.00%9013541.00%Food30%225.0077.00%22530.00%225-172.562.00%Travel7%52.5084.00%52.57.00%52.567.580.50%Other16%120.00100.00%12016.00%12092.00%Above0%20%35%47%77%84%Equal/below20%35%47%77%84%100%Cost 150.00 112.5090.00 225.0052.50 120.000.01 150.00-0.02 150.00-0.03 150.00-0.04 150.00-0.05 150.00-0.06 150.00-0.07 150.00-0.08 150.00-0.09 150.00-0.1 150.00-0.11 150.00-0.12 150.00-0.13 150.00-0.14 150.00-0.15 150.00-0.16 150.00-0.17 150.00-0.18 150.00-0.19 150.00-0.2 150.00-0.21-112.50-0.22-112.50-0.23-112.50-0.24-112.50-0.25-112.50-0.26-112.50-0.27-112.50-0.28-112.50-0.29-112.50-0.3-112.50-0.31-112.50-0.32-112.50-0.33-112.50-0.34-112.50-0.35-112.50-0.36-90.00-0.37-90.00-0.38-90.00-0.39-90.00-0.4-90.00-0.41-90.00-0.42-90.00-0.43-90.00-0.44-90.00-20%15%12%30%7%16%GasElectricityWaterFoodTravelOtherColoured Variable Width Columns050100150200250%ShareCost()The colour fill is created using 6 extra data series on the secondary axis,chartedas a stacked column.Format the new dataseries to have the colour you want.Remember to remove the border otherwise the colour will appear striped!It requires a lot of extra cells to provide the information BUT the effect is prettycool.The matrix of numbers can be easily populated using formula.0.45-90.00-0.46-90.00-0.47-90.00-0.48-225.00-0.49-225.00-0.5-225.00-0.51-225.00-0.52-225.00-0.53-225.00-0.54-225.00-0.55-225.00-0.56-225.00-0.57-225.00-0.58-225.00-0.59-225.00-0.6-225.00-0.61-225.00-0.62-225.00-0.63-225.00-0.64-225.00-0.65-225.00-0.66-225.00-0.67-225.00-0.68-225.00-0.69-225.00-0.7-225.00-0.71-225.00-0.72-225.00-0.73-225.00-0.74-225.00-0.75-225.00-0.76-225.00-0.77-225.00-0.78-52.50-0.79-52.50-0.8-52.50-0.81-52.50-0.82-52.50-0.83-52.50-0.84-52.50-0.85-120.000.86-120.000.87-120.000.88-120.000.89-120.000.9-120.000.91-120.000.92-120.000.93-120.000.94-120.000.95-120.000.96-120.000.97-120.000.98-120.000.99-120.001-120.00ScaleLabel Y ScaleLabel Text020%015%012%030%07%016%20%15%12%30%7%16%GasElectricityWaterFoodTravelOtherColoured Variable Width Columns050100150200250%ShareCost()The colour fill is created using 6 extra data series on the secondary axis,chartedas a stacked column.Format the new dataseries to have the colour you want.Remember to remove the border otherwise the colour will appear striped!It requires a lot of extra cells to provide the information BUT the effect is prettycool.The matrix of numbers can be easily populated using formula.Variable Width ColumnsXYTopDownUpScaleLabel X%Share Cost()01501500Gas20%150.0020.00%15020.00%150-37.510.00%Electricity15%112.5035.00%112.515.00%112.5-22.527.50%Water12%90.0047.00%9012.00%9013541.00%Food30%225.0077.00%22530.00%225-172.562.00%Travel7%52.5084.00%52.57.00%52.567.580.50%Other16%120.00100.00%12016.00%12092.00%Original DataCorner points of column barsX Error bars-to make the tops of the columnsY Error bars-to make the sides of the columnsData and labels for new X Axis scale20%15%12%30%7%16%GasElectricityWaterFoodTravelOtherVariable Width Columns050100150200250%ShareCost()The columns are created by using the X&Y Error bars on a XY-Scatter chart.All the additional values are calculated from formula.The X axis and column labels are data labels linked to cells.As always use either of these free addins.Rob Boveys Chart Labeler,http:/ John Walkenbachs Chart Tools,http:/j-One problem with this method is the lack of colour.I have demonstrated a work around,although it does require largeamount aof additional data.If my method is not to your liking check out Stephen Bullensexample,FunChrt5(http:/www.bmsltd.co.uk/Excel/Default.htm)ScaleLabel Y ScaleLabel Text020%015%012%030%07%016%20%15%12%30%7%16%GasElectricityWaterFoodTravelOtherVariable Width Columns050100150200250%ShareCost()Variable Width ColumnsXYTopDownUpScaleLabel X%ShareCost()01501500Gas20%150.0020.00%15020.00%150-37.510.00%Electricity15%112.5035.00%112.515.00%112.5-22.527.50%Water12%90.0047.00%9012.00%9013541.00%Food30%225.0077.00%22530.00%225-172.562.00%Travel7%52.5084.00%52.57.00%52.567.580.50%Other16%120.00100.00%12016.00%12092.00%1.210.80.60.40.20050100150200250Series105010015020025005010015020025005010015020025005010015020025020%15%12%30%7%16%05010015020025005010015020025020%15%12%30%7%16%GasElectricityWaterFoodTravelOther050100150200250You can continue to format the chart to own taste.Have a look at the Coloured worksheet if empty columns looks a little to boring!20%15%12%30%7%16%050100150200250ScaleLabel Y ScaleLabel Text020%015%012%030%07%016%Use the chartwizard to create an XY scatter,pointsonly,form data range D2:E8Remove Legend.Format plotarea to automatic fill.Remove gridlines.Format X axis scale Minimum=0 Maximum=1Set tickmarks and tickmark labels to noneSet X-Error bars(-)custom range to F2:F8Set Y-Error bars(+)custom range to H2:H7Set Y-Error bars(-)custom range to G2:G8Format Error bars to have Marker with no topFormat data series marker to NoneAdd a new data series,to provide X axis labels.Data series X value I3:I8Data series Y value J3:J8Format new series to have no data point marker.Link the data labels to K3:K8.See note on sheetPlain for details of chart label addinsSet X-Error bars(-)custom range to F2:F8Add another new data series,to provide Columnlabels.Data series X value I3:I8Data series Y value C3:C8Format new series to have no data point marker.Link the data labels to A3:A8.See note on sheetPlain for details of chart label addins.Add a new data series,to provide X axis labels.Data series X value I3:I8Data series Y value J3:J8Format new series to have no data point marker.Link the data labels to K3:K8.See note on sheetPlain for details of chart label addins