Subscribe Bookmark RSS Feed

X-axis modification in Graph Builder

scottahindle

Occasional Contributor

Joined:

May 18, 2017

Dear all,

Using graph builder I use "Group X" to create two graphs side by side as seen in attachment jpg. The graphs are essentially plots over time where I use the column "Sample" as the basis for the x-axis.
- Product One has 133 values
- Product Two has 234 values
In dividing the graphs, both have an x-axis based on the number of values in Product Two.
I would like to override this default and for change to, for example:
- Product One based on 1 to 140 values
- Product Two remains as is
Could anybody advise on how to do achieve this manipulation of the x-axis?

As it Product One looks as though it is missing something bcause there is a big space of "nothing" between values 134 and 240.

Thanks in advance for any tips/guidance!
Scott.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Neither the X Grouuping or the Y Grouping will allow the axes to be different.  Therefore, one has to define 2 different graphs, to accomplish what you want.  To do this, I changed the table, and duplicated the Sample  column.  I then deleted all of the sample data for product Two rows in the the first Sample column, and then deleted the sample data for the product One rows in the second sample data column.  I then changed the names of the columns to Product One and Product Two

Here are the results........I have attached the data table, which has an embedded script of the Graph Builder

2 graphs.PNG

Jim
2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Neither the X Grouuping or the Y Grouping will allow the axes to be different.  Therefore, one has to define 2 different graphs, to accomplish what you want.  To do this, I changed the table, and duplicated the Sample  column.  I then deleted all of the sample data for product Two rows in the the first Sample column, and then deleted the sample data for the product One rows in the second sample data column.  I then changed the names of the columns to Product One and Product Two

Here are the results........I have attached the data table, which has an embedded script of the Graph Builder

2 graphs.PNG

Jim
scottahindle

Occasional Contributor

Joined:

May 18, 2017

Thank you!