Forum Discussion
Line Chart with multiple lines
Thanks alot for the response, but this is pretty much I had in mind.
The issue is like I have the aforementioned data of two different months in two different sheets.
Therefore, I do not have any kind of date' column in either of the sheets. Because the data is itself aggregate of a month each and not just in discrete (date wise) manner.
The data is for example in this manner.
One sheet for Aug and one for Sept.
There are no other columns showing dates or months.
I just wish to get this data displayed in a line chart having Employees on X-axis and their sales on Y-axis where one line would show the trend for Aug month and the second line would display for Sept month.
This way both the trends in each month and between each month can be portrayed at once.
Hope you're getting what I am in need of.
The actual data is quite confidential and way different from this. Therefore need help through this example.
Rickz ,
Sorry for the delay in my response.
You can create a date column with the default date as 1st day of each month the data is from.
This way you will be able to differentiate months.
If you see below, I am just including one date column in Aug dataset
Doing the same for September dataset as well. Then combining the dataset. It looks as below
If I use this table and build my visual as explained earlier in the thread, the below is the output.
Using Month in the Legend box
Hope this clarifies
