Charts and graphs

[Tiger1]

I have a data set with date column, Day Rate column, Monthly Rate Column, and weekly rate column. I need a graph to show this based on date.

I want the graph to look like this:

[WillowMobileSys]

Since you have multiple entries on the same date and you want the chart displayed by Days, I will assume that you want each column SUMMED by the date.

1. Create a Chart view referencing this table or a Slice that includes the columns you are highlighting.
2. Make sure the Invoice Date column has been selected as the Label in the data columns.
3. Choose one of the Column Series charts (depending on your preference).
4. Choose the Group Aggregate as SUM.
5. In the Chart Columns, select the 4 data fields with the rates.

[Tiger1]

Thanks - let me try that…