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

Recent content by carics

  1. C

    line chart - time format

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

    line chart - time format

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

    line chart - time format

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

    line chart - time format

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

    line chart - time format

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

    line chart - time format

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

    line chart - time format

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

    line chart - time format

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

    line chart - time format

    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)...
  10. C

    line chart - time format

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

    Pivot Table - filter multiple values except one

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

    Pivot Table - filter multiple values except one

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

    List different entries

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

    List different entries

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