Struggling with Excel.
I have a table with an uneven amount of data points for each date.
Date fields are formatted as "Short Date".
Data fields are formatted as "General".
As you can see, the line chart doesn't reflect it properly: the x-axis is equidistant for each datapoint. Instead, I would like to have the x-axis equidistant for each date and I have already set it to "Date axis". Some dates have more data points and they should be shown in the same "date area".
A scatter plot doesn't help me much either - I can't even get the x-axis to show the right dates.
Do you know what I can do?
>>17852017
are you trying to switch the x and Y axis? you can just change what data points you want to use for each axis can't you?
>>17852024
nevermind I looked at your screencap again, would removing the in between points with no date affect your graph? Not in the chart itself but for your plot cells, thats the only way I could thing of that might change that
>>17852024
no, the x-axis should be date, and y-axis data.
see pic, this is what i'm trying to achieve.
equidistant dates, blanks for no dates, and the equidistant distribution of data points for a date.
>>17852030
actually, the "in-between points" belong to the current date. so 04.12. has 3 data points for example
can you not just plot the individual data points then run the line through them? aside from labelling the dates with a sunscripr a b and c or something i'm out of ideas
>>17852073
that's what's happening in the first line chart and it skews the trend line. it's just a wrong representation because on some dates there's a lot more happening than on others
Create a new x-axis with equidistant dates. Such as each day/weekday/week. Then do a lookup or paste of the data. For dates with no data, take the previous one.
>>17852094
What I meant by this is, create a new range of cells, one day scale, and use that as the x axis after you map that to your y axis data.
>>17852094
>>17852097
i'll try your idea in a sec.
here's what i did now (see pic).
i only filled the empty date cells with the correct dates. it seems to work... i don't really want the points to stack like that when there are more available, but it gets me so much closer to the goal now...
>>17852047
You need to space out your data if you want to space out your graph.
Find the month with the most number of data points. All months must have enough space between them to fit that many data points, even if you have fewer than that many for a particular month.