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...
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...
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...