5 Replies Latest reply on Aug 1, 2019 7:16 AM by Jim Dehner

Multiple axis problem

Hello,

I have the following issue, as I have 4 separate axes which form 4 distinct charts. When I combine them, all the charts combine, whereas what I would like to happen is a combination chart of the first and the last one.

What I fail to do, is when I dual the axes, the circles from the 3rd chart also appear. Can I specify which coordinates to be used by each distinct mark/figure?

• 1. Re: Multiple axis problem

I am not clear on what you want

this is a dual axis of 1 and 4

this is 1 and 3 and 2 and 4

and this is all 4

do any of those work for you

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• 2. Re: Multiple axis problem

I think this is what you are getting at.  When you create a dual axis chart, you really only want to duplicate one of the axes in most cases.  I have left Average(Y) as the duplicate and sync'ed the axes.

• 3. Re: Multiple axis problem

It's nearly what I wanted. "Sheet 1" is the chart which I would like to combine with the first chart of the picture.

Average(x) and Average(y) should form 81 distinct points, whereas at this point I have many more - which are coming from somewhere.

• 4. Re: Multiple axis problem

Dashboard 1 may be a closer interpretation of what you wanted.  I have sync'ed the axes of the two sheets and laid the first over the top of the second.

I made a color mistake with the dots.  Here is the updated version.

• 5. Re: Multiple axis problem

Hi Stefan and Tim - I looked at the detail data and I think what you are trying to do is plot a shape file (at least that what is in the data) and then do a point file overlaid on it

see Sarah Battersby paper  Dual Axis Mapping - Many Ways   - and see if that fits your need better

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful