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.
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.
thx Andy,
I'll try to manipulate the data with vba before plotting it.
t
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks