chirayu
Well-Known Member
Hi All,
What I mean by this is I have data like the below.
Essentially I want to create a line chart that shows day by day data instead of jumping from point to point.
I know I can do this by creating a data sheet & using Lookup to generate day by day data but that would increase filesize by a lot.
So I was wondering whether there is another way to do it
Sample Data:
Chart should create daily data using above summary
What I mean by this is I have data like the below.
Essentially I want to create a line chart that shows day by day data instead of jumping from point to point.
I know I can do this by creating a data sheet & using Lookup to generate day by day data but that would increase filesize by a lot.
So I was wondering whether there is another way to do it
Sample Data:
Code:
Carrier FROM TO PRICE
A 01-Jan-17 08-Jan-17 2200
A 09-Jan-17 14-Jan-17 2500
A 15-Jan-17 05-Feb-17 2500
Chart should create daily data using above summary