I have day by day data.
I would like to display a line chart with this daily data as well as weekly average bar chart.
How can display daily as well as weekly trend chart by only having daily data in my spreadsheet?
From the Creating a chart help page.
For the average, you can use the formula