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

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

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

Hi,

I just tried my variation of variable column widths in xl2007 and it appears
to work.
http://www.andypope.info/charts/colwidth2.htm

The area chart does have x-axis dates. On the Axis Options tab of the Format
Axis dialog is a section Axis Type.
Here you can set the type to be Automatic, Text or Date.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"George Burdell" wrote in message
. ..
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