Solved

Excel combined chart

Posted on 2002-06-14
6
857 Views
Last Modified: 2007-12-19
Ok, got a question for the excel fans

you can pickup a sample sheet with the instructions here

http://www.bredlum.com/ee_temp/hist.xls

the file contains
-data how it looked like in the original setup
-instructions what you see in the graph
-a bitmap of the resulting graph

this was originally build in APL and has to be migrated to Excel

Any takers out here?

thanks for all the feedback i get, i'm simply to lazy to do this myself it looks like *real* work

:O)Bruintje
0
Comment
Question by:bruintje
6 Comments
 
LVL 4

Expert Comment

by:Bit_Twiddler
ID: 7080676
Tried to look at your file "hist.xls" in Excel 2000 and it crashes Excel.
0
 
LVL 44

Author Comment

by:bruintje
ID: 7081150
that's funny got no problems with it on three different (xl97, xl2k, xlxp) machines
0
 
LVL 1

Accepted Solution

by:
packhorse earned 250 total points
ID: 7081178
Hi bruintje

Had a look at the graph.
Tried out an idea and it looks promising.
Produce two graphs one on top of other.
Top one has to have mainly no patterns
so as to be transparent.
Bottom graph has thick columns.
Top graph has thin columns.
Top graph has nine series.
Format of top graph:
Series 1,4,7 dark brown.
Series 2,5,8 light brown.
Series 3,6,9 no border, no fill.
Obviously the data has to be created
from your table for both graphs.
Then the two have to be lined up.

Thats the suggestion, I await others.

Regards

Packhorse
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Expert Comment

by:danish299
ID: 7087172
Hi,

 I try to opent he file my system gets booted. dont know why.
0
 
LVL 44

Author Comment

by:bruintje
ID: 7087274
that's really weird, i never have any problems with the posting there or picking up

it's too hard to put it all in text

anyone having trouble send me a reply address so you can at least have a look at it

Packhorse > thanks for the input that's the best i got so far

I want to do this in code and i know you're not going to do that for me, but i'll take your instructions and see how far i can come with it

Brian
0
 
LVL 44

Author Comment

by:bruintje
ID: 7167663
your lucky day, got the problem already solved.....

it wasn't mine anyway but from a co-worker who's into automating the stuff now.......


thanks for the suggestion
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
stop word moving down 2 49
how to add and add vat in excel 9 45
Macro 6 45
Microsoft 365 versus MicroSoft 2013/2016 8 62
Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Outlook Free & Paid Tools
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

939 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

4 Experts available now in Live!

Get 1:1 Help Now