Search results

Again thank you very much for the help. I could not understand what was going wrong so I re-took all the steps and tried to copy your chart. I now see that the problem came from adding two series of data as area chart and this was breaking my previous scattered chart. I added all the other data...

Thanks again for your help Faseeh. I posted a "final" file on the 13th of April. That is the one I cannot modify.

That is exactly what I want. But can you do that in the file I uploaded? I cannot get the same result you have. Yes, my file has other series of data, but the end result is not what I expected. I look at your settings and for once I cannot even have my axis parameters the same as yours; mine...

If you see Hui's file, the vertical axis has the stock levels, and the horizontal axis has the days. But inside those days there is hour information, so that from 1Jan to 2Jan we have multiple stock updates. That is what I wanted and I still cannot get in my file.

The file I uploaded before works perfectly except for one point. This point is working in Hui's file, which is that inside a day there are several points (in 01-01-2015 there is one for 00:00, other for 06:12, for 12:36, etc.). In my file it seems that one day is only one specific point so I...

Hi Faseeh, Thanks for the reply, but I don't really know what I am looking at. I get the chart you made in the same way as mine - only one time per day. The difference is that on mine I have date+hour and on you do not.

I did, but... "...I cannot get the chart to take data from different hours in one day. This means that if there are two different stock levels in one day, I just get a vertical line between min and max values." I uploaded a new file with the result in my post from April 13 and there is...

Any idea?

Hello Hui, Thank you very much for the tips. I think I never messed with scatter charts before, so it did not come to mind to change chart type. I have adjusted it to the real data set, adding other cool features I had in my mind from the beginning. Nevertheless I cannot get the chart to...

Sure! It is very simple as an example. I forgot to mention that this file is to be filled in by different people, so the number of entries per day will vary a lot. In this example I would like all days to have the same length in the axis and also the two missing dates in the range (5 and 6/jan)...

Hi mates, I have a series of data with 3 columns: A = date B = time (hh:mm) C = stock I want to make a chart with the time evolution of the stock. The problem is that in some days I have 6 different entries (different times and different stock) and in others I have 1 or even 0 entries. How...

bummer! But actually I noticed the other way around. My selection had only numbers, and when I excluded "0" and "blank" and refreshed with new values, also the new ones got included in the data shown... Actually that is why I asked; I had seen it both ways and if I cannot understand it then...

Good morning all, I have a Pivot Table where I am filtering out all "0" and "blank" values in the report filter for my column T. That means I end up viewing all values 1, 2, 3...... 250 and they are all selected. Next week when I refresh the PT and there is a value 251 or 1000. Will these...

Hi, Thank you very much, SirJB7. I tried that array formula and it worked perfectly. BR

I am only glad there are people knowing 10000000 times more than me willing to help. Thanks

Hi Luke M, Thank you for the reply. I took a look at it but I couln't get my preferred solution to work (formula). Actually, the macro was hard for me to follow as well, so I think I will stick to the method I already knew and used -> Pivot table + button with macro to auto refresh. BR...

Congratulations mate.

Hello, I have been trying to list all the different text entries in Column A. The goal is to then use the list for validation purposes in a form. I could do it with pivot table, but I would prefer not to. Giving it a little bit of thought, I suppose I could use a function to COUNT all the...

Luke M that is simply perfect! I am always amazed by VBA ninjas! Thank you both very much for your replies.

Hello, I am looking for a way to have cells A1 in sheet1 and A1 in sheet2 always have the same value. The action would be: - both are blank - I enter number 1 in A1 sheet1 --> A1 in sheet2 gets number 1 as well - I enter letter a in A1 in sheet2 --> A1 in sheet1 changes from 1 to...

GOT IT! In the field options I unticked the "Select Multiple Items" option and now it works... damn, that took me long enough! Thank you anyway for those who read this!

Hello, I am setting up a dashboard, and for that I would need that some Pivot Tables would filter themselves based on the value on a specific cell. I got this code until now: Sheets("INDEX").PivotTables("SFCClusterPT").PivotFields("cluster").CurrentPage = Range("BC21").Value I re-checked...

Hi SirJB7! That is perfect! I still had some trouble with the "click button to open form" thing, but I managed that after all. My new year's resolution should have been learn VBasic :) Thanks a lot for your trouble, it will help me a lot! Regards!

Hi Hui! Again, thanks a lot for the reply. I still am too dumb to get it from your explanation. I get to create a user form and design it with label and combobox. The points I do not get: 1- how can I open the form with the button on sheet1? 2- how can I fill the dropdown options with...

Hello Excellers, I have been googling this for a while but I cannot find exactly what I look for and I am not good enough to adapt the few examples I have until now. What I would need is to have a kind of a simple for to change the value of a single cell, based on the various options in a...