Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer 1

  1. From your spreadsheet, select the cells with data you'd like to include in the chart. Alternatively, you can select a range or multiple ranges of data from within the charts dialog. You can do so by clicking Select range... and entering one or more ranges by clicking Add another range.

    Note: It helps to label the data in your spreadsheet before creating a chart. For example, if you want to chart your expenses, you might have a row of numbers labeled 'Rent' and another labeled 'Groceries.' Then you might label columns by month or week, etc. These labels will appear automatically in the window where you create and preview your chart, as long as the labels are the first row and column of your selected range of cells.

  2. Select the Chart enter image description here icon in the menu bar or choose Insert > Chart. The charts dialog box appears. In the Start tab, you’re able to edit the range of cells to be included in your chart, select basic layout settings, and view recommended charts.

  3. In the Start tab, you’re able to edit the range of cells to be included in your chart, select basic layout settings, and view recommended charts.enter image description here
    Note: If you included labels for your data in your spreadsheet, you can specify that you want to use the first row and first column of your data as labels by checking the box next to ‘Use 1st row as headers’ and ‘Use 1st column as labels.’ These settings are automatically selected when you include labels in Row 1 and Column A in your spreadsheet.

  4. If you decide that one of the recommended charts isn’t the right thing for your data or if you want to see more chart options, you can either click More >> or move on to the Charts tab.

  5. Preview your chart and edit as necessary.
  6. Click Insert. The chart appears in your spreadsheet. If you would like to go back to editing your spreadsheet without an inserted chart, click Cancel.

From the Creating a chart help page.

For the average, you can use the formula =ArrayFormula(AVERAGE(IF(A1:A7 <> 0; A1:A7))). To use this formula within the chart instead of its value, I don't know how to do it or even if it's possible. You could, however, add another cell (say A8) in which you compute the average value for the respective week and use that value to make you average values chart.

share|improve this answer
    
How does this answer the question of average weekly values? I know how to add charts. I'm using trending graph to display my daily values. But I don't know how to display weekly averages which would be a better trending display. –  Robert Koritnik Sep 22 '11 at 11:36
    
You want the graph to use a formula instead of values? That's what you are asking for? –  Alex Sep 22 '11 at 11:50
    
I don't know what I want exactly. I just want a chart that would show me weekly trend along with my daily data. This actually means I would like to display weekly average (or total sum) with daily values. And I can't figure it out whether Google charts can do such thing without adding additional columns - which I also don't know how to do it so only one value per week would be added but chart would extrapolate it to 7 days. –  Robert Koritnik Sep 22 '11 at 13:54
    
I've also edited my question a bit to make it more clear. –  Robert Koritnik Sep 22 '11 at 13:56
    
For the average you can use this formula =ArrayFormula(AVERAGE(IF(A1:A7 <> 0; A1:A7))). To use this formula within the chart instead of its value, I don't know how to do it or even if it's possible. You could, however, add another cell (say A8) in which you compute the average value for the respective week and use that value to make you average values chart. –  Alex Sep 22 '11 at 18:48
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.