Forum Discussion
Line Chart with multiple lines
Hi all! There's this condition like I have a data of number of items sold in the month by 10 employees in two months. E.g., John sold 100 packets in July and 120 packets in Aug. The data is alrea...
Hi Rickz ,
If you keep the tables separate, this is how it will behave.
Do the following steps.
1. Append both the tables. The Resultant table will be having all the 3 columns Employee Name, Month and No of Packets column in it.
2. Create a line chart as below
x-axis should be month
y-axis should be Total Sales
Legend should be Employee Name
This way you will have two lines, One for each employee trending over Months in x-axis
Regards,