• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

chart automation

P

Pradeep Pradhan

Member
Hello !


can anybody help to develop a graphical chart with check boxes. One check box represents date range ( from ... to) which need to be feed manually. Other check boxes represent different variables(each column in excel ).

Data for these variables are entered on daily basis.so whenever anyone put date range & name other variables,chart will display it automatically.


Say for example there are five mixes which are prepared on daily basis for next 6 months.These mixes have different properties, say density,volume etc. so whenever a mix name & date range is entered on chart,it automatically takes data from table & display it for a particular variable( density or volume).

Each mixes has
 
Hi Pradeep,


Upload it to some free file hosting service and drop a link here. Make sure one need not to log in to down load.


Faseeh
 
Dear Faseeh,

Here is the link:


http://www.fileconvoy.com/dfl.php?id=gd98a73429ac51d08999226169ba2d08bd6dfcb579


Request you to resolve it soon pls. it is very urgent
 
Hi,


Please review this file and let me know..


http://dl.dropbox.com/u/60644346/Variable%20Chart%20Plot.xls


Faseeh
 
Hello Sir!


This is really fabulous!!!.

"Quality Name" as shown in "A" column is to be shown in the chart as you did for "W" column. Batch no of particular quality is also to be displayed


can one upper working limit & lower working limit be shown in the chart?


Pls share me the entire procedure of doing it as i need to do it myself.


Thanks
 
Hi Pradeep,


Thanks for your remarks, can you please see this file:


http://dl.dropbox.com/u/60644346/Variable%20Chart%20Plot%202.xls


I have added the criteria of Quality name as well. I will explain it letter as i am occupied with some work, hope this file works for you.


Faseeh
 
Hello Faseeh,


In the last file you uploaded only one date is being displayed on chart even if data are available on different dates. Other dates need to be displayed on chart


Pls observe file once again. Each quality has different batch no on column"B".May be one quality has different batches on same date & on different dates.say for example 4 batches are made on 24/05/2010 of ifa 21 w quality & further 2 batches are made on 25 th. These batch nos along with dates required to be displayed on chart on X axis when particular quality is entered on " w" column & date on "T" & "U" column.


we are very close to solve this boss.


regards,

pradeep
 
On the chart select x axis, right click select format axis goto axis options and change major unit and minor unit to auto and if u find any problem drop an email to faseeh10[at]hotmail[dot]com


faseeh
 
Hello faseeh


can u pls explain following:


1)how to draw two straight line on a chart , one showing maximum limit & other one for minimum limit.


2) the formula u used in "A" to "I" column of helper sheet. I dont understand logic.


pls add me on skype.


regards,


pradeep
 
Dear Pradeep, I have already added u to the skype, emailed and confirmed u the same.. I will shortly upload n email u the explanation.


Today is an audit in my office and am too much occupied with work on floor so as soon as i reach my pc i will do this.


Hope u understand,


faseeh
 
Hi Pradeep,


Please see this file for explanation of formula:


http://dl.dropbox.com/u/60644346/Hi%20Pradeep.docx


Please go through this link for adding horizontal lines to charts.


http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html


..and sorry for the inconvenience.


Faseeh
 
You must log in or register to reply here.
Back
Top