Forum Discussion
Presenting weekly data in one view in graph
I need to get my 2019--> weekly data to be presented in one view. If i have the week number as in format yyyy/ww the graph ends up presenting all the values and thus, the graph needs to be scrolled horisontally:
And if I change the format to yyyyww and to be as whole number, the graph expects there to be values in between the last and first week of the year, and fills the missing values with a line. As in between 201952 and 202001.
Now if I change the X-axis type from continuous to categorical, I end up scrolling horisontally. Is there a way to present the weekly data in one view without the need of scrolling or that the graph fills the missing values?
6 Replies
Hi Anonymous ,
Unfortunately, this is due to the design of the line chart. If you need a view without scrolling, then you need to set the x-axis to continuous, but that will result in autofill. Consider creating a stacked column chart, which do not autofill.
If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.