sethspearman
New Member
- Joined
- Apr 15, 2010
- Messages
- 11
Hello,
I have a simple spreadsheet with dates in a column and a numeric value in another column. This data has been collected every day for a year.
I want to create a line chart out of these two columns with dates on the x-axis and the number as the data point for my line.
I want this same data source to show charts for daily, weekly, and monthly.
Can I create three separate charts and will the chart aggregate the data for the weekly and monthly versions or do you have to do the aggregation in the source before creating the chart.
If you can do it in the chart directly can you tell me how? I can't figure it out?
Seth
I have a simple spreadsheet with dates in a column and a numeric value in another column. This data has been collected every day for a year.
I want to create a line chart out of these two columns with dates on the x-axis and the number as the data point for my line.
I want this same data source to show charts for daily, weekly, and monthly.
Can I create three separate charts and will the chart aggregate the data for the weekly and monthly versions or do you have to do the aggregation in the source before creating the chart.
If you can do it in the chart directly can you tell me how? I can't figure it out?
Seth