On my Excel file I have each month on a column and I need to be able to make this a 'date' so i can use lines to represent my data.
Here is what I have so far:
I would like to view the same but instead of blocs I need lines.
Check below link
Clean Data from Excel, CSV, PDF, and Google Sheets with Data Interpreter
You have created similar data:
follow the below steps:
1. original data
2. Pivot the data and change the datatype of month to date.
3. Drag month and value to sheet.
Retrieving data ...