Thread: by what function can graph automatically drawn?

hey

i have a graph thats is drawn from 2 columns 1 for the x axis and the other for the y axis, actually the column of the y axis conatins about 30 cells but 5 or 6 cells are the only conatins numbers and the other cells contains "-" the problem that every day the filled cells change and i want the excel to automatically detect which cells conatins the data and takes the values of y axis and x axis from them.

is this possible to do?

hey

i have a graph thats is drawn from 2 columns 1 for the x axis and the other for the y axis, actually the column of the y axis conatins about 30 cells but 5 or 6 cells are the only conatins numbers and the other cells contains "-" the problem that every day the filled cells change and i want the excel to automatically detect which cells conatins the data and takes the values of y axis and x axis from them.

is this possible to do?

Hi Shimi,

The attached workbook might be the sort of thing you're after - the only problem is that it's a bit difficult to (briefly!) explain how it works.

If you think this approach could be useful, post a copy of your workbook and I'll see if I can make the necessary changes to it.

Regards,

Greg M

dear greg

thank you so much 4 your help, the way the graph is drawn is exactlly what i want.
i failed to send you the worksheet beacise it is larger than 100 kb if you can give me your mail i can send it to you to look at it and tell me how to do it you 'll find in the file 31 sheets the month days, i want to enter each day the productivity of each part and the daily graph automatic selects the parts that worked and draw the graph for them

i really appereciate your help
thnx so much

what is NA() formula?

Hi shimi,

I'll send you my e-mail address in a forum PM.

The NA formula is entered in a cell as =NA(), and displays in the cell as #N/A. It's useful when graphing data, as points which have an #N/A value are ignored, whereas points with values of -, blank etc. are considered to have a value of zero and the graph reflects this.

I'll take a look at your workbook & see what I can do.

Regards,

Greg M

Hi Shimi,

Take a look at the attached workbook and see what you think.

I've played around with your original, and now the workbook contains a single graph with a dropdown list which enables each working day of the month to be selected for display - a "working day" is a day for which some output exists. You can also use buttons to jump backwards and forwards between the graph sheet and the data sheet for the day being displayed.

I've removed the graphs from the individual data sheets, but I can probably replace them if you feel it's necessary.

How are the Late Quantities handled? I haven't done anything about including them in the graphs. Are they added to the "normal" quantities for that day?

Anyway, have a look at what I've done & let me know if we're going in the right direction.

Regards,

Greg M


P.S. I'm having great difficulty uploading this (<100kB) file, it's taking absolutely forever, so I'll send you a copy by e-mail.

Hi Shimi,

I finally got that file to upload!

Regards,

Greg M

Dear Greg M

first i'm soooo sorry for my late reply but i've been very busy the last days
second Thank you sooooooo much the file you sent to me is more than great it's exactly what i needed to do really i want to thank you fro your dedicated effort
seond i need a another favor from you , could you explain to me how such amazing thing is done on excel even or in simpler way i managed in your file to discover the hidden worksheet which contains the data i choose all i need is to understand is how this worksheet works and secondly how the graph is shown in the other worksheet

dear greg really thank you for your great help

yours Ahmed Shimi

Hi Ahmed,

Many thanks for your feedback - it's nice to have such a satisfied customer! You're very welcome and I'm pleased I was able to help you.

Regarding the question of how the workbook works, it's a bit complicated, but I'll try at least to help you understand it.

The most significant thing is that the graph gets its parameters from DYNAMIC NAMED RANGES on the Graph Data worksheet - this is the key to the whole thing. So, for your homework, have a look at the series used in the graph and see if you can figure out where they're located - even better if you can figure out how they're generated! Then ask me whatever questions arise as a result of your "investigations". Please don't think I'm trying to avoid your request, but the application covers quite a few topics, and to explain all of them "from square one" would involve an awful lot of typing by me. So let's work together on helping you to understand it.

Best regards for the time being,

Greg M