Forum Discussion
Line and Clustered column chart
My dataset is as follows: My chart displays data as follows: The line chart which is ratio displays by YEar and not by month. Can someone please help?
Hi Anonymous ,
Sorry,but I'm not very clear about your requirement...Maybe you want to use a hierarchy on the X-axis?
In addition,I noted that the value in Month of "September" is misspelled in your data sample.
After corrected it, you could use the following formula to create a new column and then set the data type as "Date",then format it as "Month year(mmmm,yyyy)". So that you could use this column as X-axis and use a date hierarchy like this:
Is the result what you want? If not, please upload some detailed data samples and expected output.
Please do mask sensitive data before uploading.
Best Regards,
Eyelyn Qin
Hi Evelyn,
This does not solve my solution.
The graph I have is drawn in Python, I'll upload some screenshots