G
gschake
I'm trying to create a chart showing the number of orders per week fo
each of our customers.
Each row (excluding header) in my Data Worksheet is an order wit
Client Name and Week# that the order was placed in.
I have a pivot table with "Client Name" in the page field and Week
and total (count) displaying correctly. I need the X axis to remai
static for all 52 weeks (with labels) and not adjust and show just th
weeks with data.
I tried creating 2 more columns to chart from. Week (a list wit
values of 1 - 52) and Total. I'm trying to pull data from the pivo
table to fill the Total column for each of the Weeks using OFFSET an
MATCH functions, then with #N/A values returning I started delving int
an IF(ERROR.TYPE) function that reads:
=IF(ERROR.TYPE(OFFSET($A$6,MATCH(20,$A$6:$A$58,0),2))=7,0,OFFSET($A$6,MATCH(20,$A$6:$A$58,0),2))
This seems way to complicated for a simple chart. Is there a bette
solution
each of our customers.
Each row (excluding header) in my Data Worksheet is an order wit
Client Name and Week# that the order was placed in.
I have a pivot table with "Client Name" in the page field and Week
and total (count) displaying correctly. I need the X axis to remai
static for all 52 weeks (with labels) and not adjust and show just th
weeks with data.
I tried creating 2 more columns to chart from. Week (a list wit
values of 1 - 52) and Total. I'm trying to pull data from the pivo
table to fill the Total column for each of the Weeks using OFFSET an
MATCH functions, then with #N/A values returning I started delving int
an IF(ERROR.TYPE) function that reads:
=IF(ERROR.TYPE(OFFSET($A$6,MATCH(20,$A$6:$A$58,0),2))=7,0,OFFSET($A$6,MATCH(20,$A$6:$A$58,0),2))
This seems way to complicated for a simple chart. Is there a bette
solution