Difficult line graph axis

[oticonaus]

I need to represent the follwoing on a line graph

X-Axis Value
*1000 25
*2000 30
3000 29
*4000 40
6000 38
*8000 31

I don't want to see the label for 3000 and 6000, but I want to see the data plotted. Also, I need those with an asterisk to be equally spaced (in other words, 3000 and 6000 sit halfway between points). I hope that makes sense.

I am trying to do this on an Access Report.

Is this possible?

 

[SkipVought]

Hi,

I do not understand several things.

1) "I don't want to see the label for 3000 and 6000"

What are the lables for everyting else?

2) " need those with an asterisk to be equally spaced (in other words, 3000 and 6000 sit halfway between points)."

Is not 3000, 1000 from the values on either side and 6000, 2000 from the values on either side?

Your statememts are not at all clear!

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[oticonaus]

Sorry, I should have been clearer. The X-Axis values are data labels. So there is only one line on the graph.

For clarity, let's say the data is

A 25
B 30
C 25
D 35
E 31
F 29

So, there are 6 equal labels on the x-axis (A-F), and one data line plotted (25,30,25,35,31,29).
The catch is that I don't want to see the third and fifth labels (C and E). So the X-Axis labels would be A B D F.
However, I still want to plot the data for C and E (25 and 31).
To make matters worse, I want the plot points for A B D F to be equally spaced, and C and E to sit halfway between points.

I hope that is a little clearer..?

 

[SkipVought]

You have specified an almost impossible situation with a Category Axis.

What is the business case for this requirement?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[oticonaus]

The business case for this graph is to represent an audiogram which is a graph representing hearing loss. To be considered technically correct, that is how the graph must be presented (unfortunately).

I think I may have come up with an alternative by mucking around in Excel.

I have created 3 series to represnt the one line. Say the data I want to graph is 10,20,30,40,50,60 with the labels a,b,c,d,e,f,g and I want the third and fifth values to be intermediate points and not labelled.

I then make the label data a,*,b,*,d,*,f
Series 1 is recorded to be 10,*,20,*,40,*,60.
Series 2 is calculated as 10,15,20,30,40,50,60 (where 15 = (10+20)/2, 30 = (20+40)/2 and 50 = (40+60)/2)).
Series 3 is recorded as *,*,*,30*,50,*.

Then, I format Series one with the required marker (an open circle), and Series two is formatted WITHOUT a marker - so it is just a plain line that follows the same path as Series 1. Then Series 3 is formatted with the same marker as Series 1 (again, the values sit on the same line as Series 1).

So what I end up with is a line graph with a single line, but 2 points which are 'intermediate' and don't have labels.

It is a bit messy in retrospect, but if it has to be done...

 

[SkipVought]

Make 3 columns: Label, Data, Data2
[tt]
CategoryX: A2:A5
Series1: B2:B5 PRIMARY
Label Data
A 25
B 30
D 35
F 29
Series2: C2:C10 SECONDARY
Data2




25

31


[/tt]
FIRST plot label & Data
next copy c2:c10
Select the chart -- Edit/paste special
With the NEW series SELECTED:
> Format Data Series - Axis Tab - SECONDARY
> Chart Options - Axis Tab - SECONDARY CATEGORY Axis

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[oticonaus]

As I mentioned in my first post, I need to generate this graph on an Access report. I was just mucking around in Excel to try to come up with a solution as it is much easier. I have been able to implement this solution in Access now - it's just seems a rather messy solution.

 

[SkipVought]

Sorry.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}