Mekko charts in Excel 2007

George Burdell · External Since: Apr 18, 2007 Posts: 2

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

Tushar Mehta · External Since: Apr 13, 2007 Posts: 24

In article ,
gburdell.RemoveThis@nowhere.com 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

George Burdell · External Since: Apr 18, 2007 Posts: 2

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/NonNative.html#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
> In article ,
> gburdell DeleteThis @nowhere.com 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

Andy Pope · External Since: Mar 23, 2007 Posts: 182

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/NonNative.html#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
>> In article ,
>> gburdell RemoveThis @nowhere.com 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
>
>

KAY · External Since: Jan 11, 2011 Posts: 2

I have a macro written for Excel (2007 & 2010) that will create a mekko for you. Email me and I'll gladly send it to you.

> On Wednesday, April 18, 2007 8:56 PM George Burdell wrote:

> 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

>> On Thursday, April 19, 2007 12:37 AM Tushar Mehta wrote:

>> gburdell.DeleteThis@nowhere.com says...
>> Check out Stephen Bullen's funchrt5.zip at
>> http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting

>>> On Thursday, April 19, 2007 8:35 AM Andy Pope wrote:

>>> 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
>>>

>>> Submitted via EggHeadCafe
>>> ASP.NET In-Memory Image Control with Built-In Resizing of Posted File
>>> http://www.eggheadcafe.com/tutorials/aspnet/e1a14e2c-e746-4bed-a552-24...2bd2709

Nick Moran · External Since: Jan 27, 2011 Posts: 1

Hello Kay,

The old Mekko macro that I had for Microsoft 2003 doesn't seem to work for 2007. Do you have a version that will work?

Thanks!

Nick

> On Wednesday, April 18, 2007 8:56 PM George Burdell wrote:

> 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

>> On Thursday, April 19, 2007 12:37 AM Tushar Mehta wrote:

>> gburdell DeleteThis @nowhere.com says...
>> Check out Stephen Bullen's funchrt5.zip at
>> http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting

>>> On Thursday, April 19, 2007 8:35 AM Andy Pope wrote:

>>> 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
>>>

>>>> On Tuesday, January 11, 2011 10:15 AM KAY wrote:

>>>> I have a macro written for Excel (2007 & 2010) that will create a mekko for you. Email me and I'll gladly send it to you.

>>>> Submitted via EggHeadCafe
>>>> WCF Generic DataContract object Serializer
>>>> http://www.eggheadcafe.com/tutorials/aspnet/59ae2b9e-a3be-4cd5-a0ef-93...abbdc3a

KAY · External Since: Jan 11, 2011 Posts: 2

This thread is mirrored over at pcreview.co.uk forums.

http://www.pcreview.co.uk/forums/mekko-charts-excel-2007-a-t3052769.html

Under the username of 67L48, I have uploaded an Excel 2010 file that can generate a 15x15 mekko (such as 15 markets and 15 companies).

Hope it works for you. Sometimes, when I first run the macro, it churns for quite a long time (almost like it's broken into an infinite loop). I think it's because I'm a poor programmer and my code is cumbersome. May also have to do with initialization of certain routines into computer RAM, as subsequent mekko generation is quick

Submitted via EggHeadCafe
SQL Operations on a Text File with ADO.NET
http://www.eggheadcafe.com/tutorials/aspnet/37ed9e1b-c5de-4c0b-afbe-d8...f9a6ecf

oliver hesketh · External Since: Jan 31, 2012 Posts: 1

Kay - if you could please let me know where I can get hold of your excel file that helps with Marimekko I'd be very grateful... it's doing my head in at the moment!!

> On Wednesday, April 18, 2007 8:56 PM George Burdell wrote:

> 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

>> On Thursday, April 19, 2007 12:37 AM Tushar Mehta wrote:

>> gburdell RemoveThis @nowhere.com says...
>> Check out Stephen Bullen's funchrt5.zip at
>> http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting

>>> On Thursday, April 19, 2007 8:35 AM Andy Pope wrote:

>>> 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
>>>

>>>> On Tuesday, January 11, 2011 10:15 AM KAY wrote:

>>>> I have a macro written for Excel (2007 & 2010) that will create a mekko for you. Email me and I'll gladly send it to you.

>>>>> On Thursday, January 27, 2011 11:10 AM Nick Moran wrote:

>>>>> Hello Kay,
>>>>>
>>>>>
>>>>>
>>>>> The old Mekko macro that I had for Microsoft 2003 doesn't seem to work for 2007. Do you have a version that will work?
>>>>>
>>>>>
>>>>>
>>>>> Thanks!
>>>>>
>>>>>
>>>>>
>>>>> Nick

>>>>>> On Thursday, January 27, 2011 11:57 AM KAY wrote:

>>>>>> This thread is mirrored over at pcreview.co.uk forums.
>>>>>>
>>>>>>
>>>>>>
>>>>>> http://www.pcreview.co.uk/forums/mekko-charts-excel-2007-a-t3052769.html
>>>>>>
>>>>>>
>>>>>>
>>>>>> Under the username of 67L48, I have uploaded an Excel 2010 file that can generate a 15x15 mekko (such as 15 markets and 15 companies).
>>>>>>
>>>>>>
>>>>>>
>>>>>> Hope it works for you. Sometimes, when I first run the macro, it churns for quite a long time (almost like it's broken into an infinite loop). I think it's because I'm a poor programmer and my code is cumbersome. May also have to do with initialization of certain routines into computer RAM, as subsequent mekko generation is quick

aloysius.martins · External Since: Aug 15, 2012 Posts: 1

On Thursday, January 27, 2011 10:57:24 AM UTC-6, KAY wrote:
> This thread is mirrored over at pcreview.co.uk forums.http://www.pcreview..co.uk/forums/mekko-charts-excel-2007-a-t3052769.htmlUnder the username of 67L48, I have uploaded an Excel 2010 file that can generate a 15x15 mekko (such as 15 markets and 15 companies). Hope it works for you. Sometimes, when I first run the macro, it churns for quite a long time (almost like it's broken into an infinite loop). I think it's because I'm a poor programmer and my code is cumbersome. May also have to do with initialization of certain routines into computer RAM, as subsequent mekko generation is quick Submitted via EggHeadCafe SQL Operations on a Text File with ADO.NET http://www.eggheadcafe.com/tutorials/aspnet/37ed9e1b-c5de-4c0b-afbe-d8...f9a6ecf

Hi Kay,
Is there any way to extend the file that you posted (15x15) to (15*100). ie 100 rows. I know that seems like a lot but it would work perfectly for what im trying to do. This would be a huge help!