I need a graph in which the user can choose which data series are being displayed, using checkboxes.
at the same time the user needs to be able to scroll from older to newer data and scroll to choose how many days data is being shown for. (2 different scrollbars would be more than acceptable)
my two data series are PNL & QTY, each getting their own y axis
my x-axis are the dates
attached is a portion of my total data (3 months worth) entitled 'pnl_qty'
please help, it is greatly appreciated!
Hi Marin,
See the attached file in which I have tried creating the chart as per your remarks.
Hope this helps.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
thank you for your help
unfortunately the file is not opening correctly for me and i am unable to see what you have managed to come up with
i get an error saying that there is unreadable content that excel is not able to repair or remove, catastrophic failure line 2, column 18835 ???
i am working in excel 2007, if this helps
Hi Marin,
Converted the file in .xls format which should open easily. Let me know if this works. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
thank you, that one opened just fine!
is there a way to make it a line graph and have the check boxes still work?
also, is it possible to have a second scroll bar that the user can use to determine how many days are shown on the graph? (the user can stretch the graph to their own liking?)
is it also possible that pnl's y-axis in dollars can be on the right of the graph while qty's y-axis in numbers is on the right side of the graph?
your help is greatly appreciated!!
Hey Marin, You are welcome friend. Cheers
Regarding your point no. 2, I do not find that is required as if a user will display more days, the chart will become little hoch-poch (UN-readable), hence would suggest you to drag the chart data towards right side, till you want it to be shown on the graph - may be bi-monthly or monthly and adjust the chart data range accordingly (that's why I have shown chart data to you, which was earlier hidden behind the chart. See the attachment.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Oops .. missed the attachment.
Now attached.
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Hi,
Possibility to improve the sum of ‘total qty’ and ‘total pnl’, it could be a sophisticated formula but a simple one as suggested in the attached file will suffice.
Cheers
Raza
thank you this looks great!
is there a way to make it so when a check box is unchecked the line goes away completely instead of just moving to the bottom of the graph?
also, is it too much to ask if i wanted to know how you went about creating this so i could add to or edit at my will when i have more data i need to input?
thanks again
also, not sure if this helps but attached here is a similar example of a graph i am looking to create
Hey Marin,
It's good you liked it. Thanks for that.
Also, I am not able to see the latest attachment from your side.
To know how I created this, check the data which is behind/ top of the chart. This data set is fetched through a s simple offset formula. The scroll button (spin button) which you there is a form control, which generates the numbers (1,2,3, etc) if you scroll them right and this numbers are linked with cell H1. Right click on this and choose Format control to see other options. The two check boxes are also part of form control and if checked / unchecked fetches True / False and these are linked to cell F1 and G1.
Hope this helps.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
what i was trying to attach before
Hi marin,
Have checked your file.
After un-checking the check box on your file, the graph here also gets dropped along with y-axis, hence this piece is ok.
Also you can have more number of data points on y-axis in my solution as well as you have in your example. See the data set behind / top of the chart and drag the formula to fill towards right side and then you can adjust the chart data range to accommodate this extension.
Hope this helps.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
great, thanks so much!
is there a way to add scroll functionality to the graph "PNL & QTY" (it already has check boxes added in the way i wish them to be used)
sheet title 'checkboxes' in the attached file '1992'
Hi marin,
See the attached file where I have shown the spin (scroll) button to select the two lines as well but I believe that check box is still the good option.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks