X-axis modification in Graph Builder

Community Trekker

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

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

Jim
5 REPLIES

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

Jim

Community Trekker

Joined:

May 18, 2017

Thank you!

Community Trekker

Joined:

May 18, 2017

You kindly helped me some weeks back on x-axis modification in Graph Builder.

I have the same problem again but this time with five "conditions" so a division of the chart into five partitions. (Last time it was two.)

How would you modify the x-axes to well represent each case (e.g. "ONE" is composed of 16 values, "MIDDLE" 87 values) meaning the length of the each x-axis is adapted to the number of values to be plotted in each case?

Is it possible without scripting? If not, could you help out with the scripting for this task?

See attached for the file I am working with.

Thank you, Scott.

Super User

Joined:

Jun 22, 2012

I assume this is what you want

It was created using your data table with no changes.  You just need to drag each column separatly to the X axis.  Documentation on Graph Builder is available at:

Help==>Books==>Essential Graphics

Graph Builder is Chapter 3, and the specifics for how to create the multiple axes is on page 42.

Jim

Community Trekker

Joined:

May 18, 2017

Thanks, Jim.

Like many things in life. When you know how it is really easy. It requires a knack to hit the x-axis in the right way to get the partitions as I need.

Much appreciated!