I have more charts on this sheet and need to update ranges with new data. stuck at reading ranges from collection. I keep getting message type mismatch or block with block missing. chatGPT wasted 2 days but could not read it. only able to read whole series but not range and niether can extract...
Thanks. I will integrate it into my master file and will let you know if any question.
One more question I am struggling with: in same chart, How can vba read .value and .Xvalue of chart series. Reason of reading is to update the ranges when new data comes in.
Some other expert helped me then I modified the code with my requirements. I spent months to understand and make it working for first step. Now I am stuck at next step. cell BG1 is connected with scrollbar and then scrollbar is connected with chart.
Thanks for response. Actually I my knowledge is basic and trying to learn as I hit the problem. BG1 is current value of scroll position. We can fill it indirectly either through vba or referencing other cell value. No rush, please help. Thanks.
I have excel line chart and a vertical scrollbar connected with it. Right now it is working fine. =.> scrolling up decrease the display range on chart (min & max values). And scrolling down increases the chart display range on chart (min & max values).
But sometime I get data and we want to...
I am sorry. Last 2 of your sheets were password protected so do not know what was the code. I had to work on different project, now came back and have these questions. I am using the code that I can understand and use that's why have problems.
Is there a way in vba, we can lock scrollbar (so no...
Hey BOSS: I need help in excel/VBA charts. I AM STILL STRUGGLING. It is continuation of the previous work you helped. I thought it is good to ask you because you know this topic very well.
From your work I learned and try to improve my end file but still have issue that I can’t figure out and...
Solution you provided works like magic. One more question related to your solution. Step =30 is display on chart and Move = current position of scroll. When I click on scrollbar, chart changes the display with multiple of 30. (for example it shows: 1 to 30, when I click on scrollbar once , it...
Excel 2007, I have dynamic line chart connected with scrollbar and dynamic named ranges are connected with chart and scrollbar. Plot area leaving gaps at top and below. I am struggling with this display issue and got crazy now. To fix it, with some help I got a vba code that works but 2 issues...
Thanks for looking at it. I will try to use spin buttons instead if that will skip all blank spaces. It is making me crazy. Even ChatGPT could not suggest proper solution. I am not concerned with horizontal values display but vertical values display is matter.
Thanks Monty. You are the first one who looked this issue deeply. Glad to hear.
Yes, I am dealing with dynamic charts through dynamic ranges. But having hard time to find the solution because I am not a good in excel programing. I switched from INDIRECT to OFFSET function. Scroll is adjusting...
Thanks for reply. I can't produce same results.
Left side axes scale is automatic 525 ... 555 ====THIS IS DYNAMIC VALUES CHANGES WITH SCROLL BAR
Right side axes scale is automatic 730 ... 760 =======THIS IS DYNAMIC VALUES CHANGES WITH SCROLL BAR
Top horizontal axes scale is 0.0 ... 150. ===THIS...
I am using Excel 2007. I have scattered line chart connected with scroll bar.
In plot area, it shows gaps/blank space at top and bottom (BLUE ARROW). There is data above and below the plotted line.
I checked my data, start to end there is no blank /empty cells.
I tried all options from Hidden...
I am rephrasing the question. I solved that part but now stuck on next step.
I am using Excel 2007. I have a chart and want to draw 2 lines with different data from same sheet (sheet name: Gamma). Then I have scrollbar want to connect with this chart. For that I am creating Range names and...
I am rephrasing the question. I solved that part but now stuck on next step.
I am using Excel 2007. I have a chart and want to draw 2 lines with different data from same sheet (sheet name: Gamma). Then I have scrollbar want to connect with this chart. For that I am creating Range names and...
Hello all, NEED YOUR EXPERT HELP.
I am using Excel 2007. I have a chart and want to draw 2 lines with different data from 2 sheets in same workbook. Then I have scrollbar want to connect with this chart. For that I am creating Range names and using name range to create lines on chart. First...
HELLO ALL. Requesting again.Simplifying question: I need to make following formula working or any other formula you suggest that can do the job would be appreciated. Following formula works but I need to add condition on it:
Current formula...
NEW XL FILE ATTACHED. I am sorry initial xl file attached had extra contents which is confusing. Please use this file instead. All other formulas in sheet were developed through your help.
Hello all:
I have only basic knowledge of excel and learning. I need expert help.
I have excel file data in columns: E, F, G, H
I need to retrieve some numbers based on some criteria: e.g. YELLOW Cells A15 & B15 where I enter search range (depth: col E).
My other formulas need to search in this...
Thanks a lot. Ctrl+Shift+Enter WORKED.
One more thing, for MIN and AVERAGE, can we set ONLY ONE condition e.g. ( find MIN and AVERAGE only values those are greater than zero then I do not need to worry what garbage values are coming below zero). If we can please help me how. I am struggling and...