Tushar, thanks for the suggestion However, Stephen's funchrt5 creates a
chart like a mekko chart, but it is not a mekko chart. Jon Peltier has an
example of a mekko chart at
http://peltiertech.com/Excel/Charts/...ml#MatrixChart. One of
steps in creating it is to change the x axis to a time series. I'll see if
I can figure out how to stack things and full the chart area. However, I
suspect that is beyond me.

It appears that Microsoft forgot to retain that capability in Excel 2007 to
change the x axis on area charts to a time series. I guess at this rate of
improvement and "depreciation" [of features] when they release Excel 3000 it
will have just one cell and no graphs, but cost a million dollars and will
consume all system resources. Aren't monopolies wonderful....


"Tushar Mehta" wrote in
message om...
In article ,
says...
I'm trying to create a mekko area chart in Excel 2007 like I do in Excel
2003. However, it appears that one can not change the X axis of an area
chart to timescale. Does anyone know how to create mekko charts in 2007?

frustrated



Check out Stephen Bullen's funchrt5.zip at
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting