Looking for some help as we are just starting to use WEBFOCUS charts. My data structure is as follows

Month Year Sales
1 2000 1000
2 2000 1500
.
.
.
1 2001 1000
2 2001 1200
.
.
.

With sales being the amount of sales for that month and year.

I want the Month to be the x axis and sales to be the Y with each year being its seperate series.

There doesn't seem to be way to do this through the GUI. I'm thinking I can probably alter the hold file to accomodate what I need but wanted to see if anyone has solved for this issue.

This message has been edited. Last edited by: FP Mod Chuck,

hi,
Here is how it can be done.
Assuming both Month and Year are Integers,
Have 2 define fields:

DEFINE A8DATE/A8MDYY=EDIT(MONTH) | '01' | EDIT(YEAR)
DEFINE MONTH_DISPLAY/MtrYY = A8DATE;


and use MONTH_DISPLAY for x-axis

quote:

DEFINE A8DATE/A8MDYY=EDIT(MONTH) | '01' | EDIT(YEAR)

Thanks for the tip but that doesn't seem to be having the desired effect. That is just extending it out for the entire timeframe.

What is being required is the x axis will be a static
Jan,Feb,Mar,Apr,May,June,July....Dec

Then I will be pulling back 4 years of data and plotting a line graph. What I need is for 2014 to be a line, 2015 to be a seperate line, 2016 to be a line, and 2017 with all four lines plotting there values for each month. Does that make sense?

In the GUI:
Sales would be the Measure
Month on the X Axis
Year would be in the Legend(Series) section.