Chart data organization

**tolio** · 11-13-2008, 07:57 AM

Hi guys,

I currently extract data that matches some criteria from a database. The extracted data comes in this form:

month | sitename | Page views

01-01-2008 | site1 | 200000
01-02-2008 | site1 | 200000
01-03-2008 | site2 | 200000

The thing is i can't chart it correctly this way, since the series values gets messed up with the x-axis. I was trying to avoid rearranging the data by finding a solution that worked this way.

Any help is greatly appreciated.

**Andy Pope** · 11-13-2008, 08:43 AM

The chart will not split the data for you.

You will need to create 2 queries if you can not construct the data as per your example.
If you use 2 record sets the x axis will need to plot true dates in order for like dates to align.