Skyline Chart

[AzadPadamsey]

Hi,
Is there a Template for creating a Skyline Chart?
Any help would be appreciated.
Regard
Azad

 

[Hui]

Azad

Firstly, Welcome to the Chandoo.org Forums

I am unfamiliar with Skyline Chart
Do you mean an Area chart or a Column Chart ?

can you post a picture or link of what you after?

 

[Debraj]

HI Azad,

Welcome to the forum..

Actually I have a template.. but not sure.. if this suitable for you or not!!

 

[SirJB7]

@Debraj(ex-Roy)
Hi, buddy!
And I wrongly thought that you were going to upload another kinda chart...
Regards!

Hi, AzadPadamsey!
If that of the previous post isn't suitable for your needs, what about this? It's a sky lined & pied chart.
Regards!

 

[AzadPadamsey]

Here is a snapshot of what I am trying to achieve.
Basically they are a lot of stacked histograms.

 

[SirJB7]

Hi, AzadPadamsey!
Could you upload a sample workbook with the source data for building a chart like you posted? It'd be very useful for those who read this and might be able to help you. Thank you.
Regards!

 

[AzadPadamsey]

Hi,
I don't have much to go by.I inheirited this file and I am trying to convert it to an Excel Chart.
Essentially,there are X amounts of activities happening per each time period.These are then stacked over each other.
Azad

 

[Debraj]

Hi

Histogram just column chart with no gap.
So you can use any column chart.. with stacked picture.

In pre 2013 version.. try to search for highlighted terms in chart formatting tool.



PS: I just got you uploaded file.. my be you can ignore this.. as you may need different picture with different text in each case.. and also conditional. may be VBA work..

 

[SirJB7]

Hi, AzadPadamsey!

I understand, what you have here is directly a range that if printed would look like that chart you're looking for.

I think that you should have a workbook with three worksheets:
1) A raw worksheet with columns like "Date" & "Sub_Sys_No"
2) A table worksheet with columns like "Sub_Sys_No" & "Sub_Sys_Description"
3) A chart worksheet with the wanted output, for which I think that you'll need something like this:
http://www.linkedin.com/groups/Coul...75693977601?trk=groups_items_see_more-0-b-ttl

Check 5th post by Andy Pope. It's nothing impossible to replicate but neither easy to do.

Regards!

 

[SirJB7]

Hi, AzadPadamsey!
Just in case you don't have a LinkedIn account, this are the links for the source and for the solution posted:
http://www.oxfam.org.uk/what-we-do/good-enough-to-eat
http://www.andypope.info/ngs/ng64.htm
Regards!

 

[AzadPadamsey]

The one by SirJB7 refering to Andy Pope is the one I am looking for.I download the file.A little comlicated
for me.Any chance of creating a simple template for me to learn.
Thanks all for your help.
Azad

 

[NARAYANK991]

Hi Azad ,

You might find this useful :

https://groups.google.com/forum/#!topic/excel-macros/A8wLx9bBcM4

http://www.geocities.jp/kenj_uda/en/Ray.html

Narayan

 

[SirJB7]

Hi, AzadPadamsey!
Neither now nor in the weekend, I will be almost unreachable and far away as I can from computers. If you can wait till Tuesday or so maybe I can be back with a template, but I don't promise anything since I haven't analyzed Andy Pope's code... and coming from him, well, let me see first.
Regards!

A little comlicated for me.Any chance of creating a simple template for me to learn.

PS: Don't worry, for me too, I guess.

 

[AzadPadamsey]

Gentlemen,
No problems.Take your time.
Many thanks.
Azad

 

[SirJB7]

Hi, AzadPadamsey!
Maybe @Debraj(ex-Roy) finds the time to dig into Pope's link and get his hands dirty with the VBA code... it's the less he could do after posting that impolite first chart (but nice, I'd recognize it)...
Regards!

 

[AzadPadamsey]

Hi SirJb7,
Have you had a chance to have a look at the Timeline Template.Does not have to have VBA.
Azad

 

[SirJB7]

Hi, AzadPadamsey!

Started giving a look, and even if the static output is visually equivalent I'm not sure if getting involved with such a complex code primarily designed to do much more things than that, like handling different data sets, animating transitions among them and displaying floating shapes with individual data.

I'm analyzing other ways to achieve your goal in a simpler way.

Regards!

 

[AzadPadamsey]

Thanks.Yes I too am not looking for complex code.I just want a non VBA chart.

 

[SirJB7]

Hi, AzadPadamsev!

Give a look at the uploaded file. It has the following worksheets:
BPQD204 MC Skyline: the damned output layout chart-alike required
Sheet4: for holding the old Sub_Sys table plus columns A:B, D:E & F, what are they for?
SubSystem: new Sub_Sys table in list form (nx2) and in matrix form ((pxq)x2)
RawData: actual data table from 1st WS, status table with format and pivot table for easy checking
SkyLine: new output

New WS are cyan tabbed and will be the only that will remain after finishing the project.

For the time being:
a) New Sub_Sys table in WS SubSystem, still with formulas for taking data from WS Sheet4, so 1st WS can't be removed now (later, after copying and pasting values)
b) New SkyLine output matching the old one, without formatting yet (haven't decided if by VBA or by CF -conditional formatting-)
c) No VBA code used, just dynamic named ranges and formulas only (but this will change with the formatting process, I guess)

Will resume about middle of next week, slightly probable on Tuesday, most probably on Wednesday, ... surely who knows.

Regards!

 

[AzadPadamsey]

Thanks,
I will study the spreadsheet.Looks promising.
Will wait until you resume next week.Many thanks for your help & effort.

 

[AzadPadamsey]

Hi SirJB7,
These are the dates I would like to use.Basicaly the Total Number of Systems that fall on each date.

 

[AzadPadamsey]

Hi SirJB7,
Have you had a chance to look at the solution?

 

[SirJB7]

Hi, AzadPadamsey!
A bit busy and couldn't finish it, hope to do it in the next working days.
Regards!

 

[AzadPadamsey]

Hi SirJB7,
Since you are so busy,do you mind if I cross post my request to another Forum?
Azad

 

[SirJB7]

Hi, AzadPadamsey!

Sorry for the late answer but been traveling the last couple of weeks. Let me shake the sand from my feet, get my hands on these things called keyboards and I'll get back to you soon.

Regards!