Excel 2003 - Catergory X Axis but not printed correctly

[Welshbird]

Hi Guys,

I have several line and column charts in a worksheet, and for all of these I have made my x axis a category and added a data table.

Now usually this means that the data table is stuck to the X_Axis, which is exactly what I want.

And that's exactly how it appears on screen. But not, however how it prints.

Is this a known blip? I've never seen it happen before.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

Fee,

And that's exactly how it appears on screen. But not, however how it prints.

How is it different when it prints?

Have you tried a different printer?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

I've tried two printers and on both I get the graph, then along the X-Axis I get each month printed, then I get the table table printed below that but not 'docked' to the axis.

But this isn't how it displays on the screen! The screen shows the data table properly docked to the x-axis.

It's really annoying too.....

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

By "not 'docked' to the axis," do you mean that the data table and chart can each be moved independently or that the x-axis category values do not align with the data table?

What kind of data on the x-axis?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

X axis is months (stored as proper months) and the table shows values for actuals and budgets each month.

So. the axis (with data table) on the screen looks like this:

[tt]
___________________________________________________
Jan-10 Feb-10 Mar-10 Apr-10 etc
Act 345 567 234 254
Bud 345 467 156 456
___________________________________________________
[/tt]
but when printed looks like this:
[tt]
___________________________________________________
Jan-10 Feb-10 Mar-10 Apr-10 etc
___________________________________________________
Jan-10 Feb-10 Mar-10 Apr-10 etc
Act 345 567 234 254
Bud 345 467 156 456
___________________________________________________
[/tt]

You see?

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[GlennUK]

What about selecting the X-Axis, and doing Format Axis, and choosing Patterns, and setting Tick Mark Labels as None? Does that help?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Welshbird]

Those options are all greyed out as the catagory axis with a data table means there isn't an axis..... until I print....

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

Look in Chart Options -- Axes, and change AUTOMATIC to CATEGORY.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

That's what I have done. Which is why I expect it to print as it appears on the screen, but it doesn't.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

When I toggle the Axes between Automatic & Caregory, it changes EXACTLY in the way that you describe...
[tt]
Automatic:
__________________________________________________
Jan-10 Feb-10 Mar-10 Apr-10 etc
___________________________________________________
Jan-10 Feb-10 Mar-10 Apr-10 etc
Act 345 567 234 254
Bud 345 467 156 456
___________________________________________________
Category:
___________________________________________________
Jan-10 Feb-10 Mar-10 Apr-10 etc
Act 345 567 234 254
Bud 345 467 156 456
___________________________________________________
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

And so it does on my screen, but not when I print the chart, and I have to produce a printed pack as well as the electronic output. I've tried three printers and it happens with all of them.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

Does this anomaly occur in Print Preview as well?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

Yes it does.

I've used catagory axis with data tables for ever - and I've never seen this happen before!

(Thanks Skip)

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

How is the Category Axes range defined in Chart > Source Data?

How are the other 2 series ranges defined as well?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

Catagory axis labels defined as:

=GraphingData!$A$14:$AM$49

and two ranges defined as:[/code]
=GraphingData!$B$14:$B$49
=GraphingData!$C$14:$C$49[/code]

Which all seems as I have done before.

Just a thought - I had installed an add-in: JWalkChartTools - could that be upsetting this?

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

I also have j-walk charting tools.

[tt]
Catagory axis labels defined as:

=GraphingData!$A$14:$AM$49
[/tt]
Assign the category to the ONE COLUMN containing your dates. Would that be Column A?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

Oh yeah - I overtyped by mistake. It is actually column A
Sorry, mistyping can hardly help you help me can it!

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

Well the guilty cannot cast stones. ;-)

We're just fishing here, so hange on.

Please FORMAT all three ranges GENERAL, Copy and Paste here, if you will.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

Catagory labels:
39448
39479
39508
39539
39569
39600
39630
39661
39692
39722
39753
39783
39814
39845
39873
39904
39934
39965
39995
40026
40057
40087
40118
40148
40179
40210
40238
40269
40299
40330
40360
40391
40422
40452
40483
40513

Data
992 1032
1992 2030
2999 2815
4006 3611
5015 4578
6042 5703
7077 6688
8122 7668
9184 8674
10262 9481
11358 10695
12478 11746
1018.16 808
2063.18 1757
3117.13 2815
4188.94 3690
5278.61 4725
6377.21 5780
7484.74 6849
8601.2 7580
9735.52 8653
10887.77 10124
12048.95 12169
13219.06 14326
1646 1875
3300 3606
4664 #N/A
6021 #N/A
7394 #N/A
8785 #N/A
10193 #N/A
11610 #N/A
13044 #N/A
14504 #N/A
15973 #N/A
17458 #N/A

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

Fee, I'm plum outta options. However, it's gonna simmer on the back burner. Sorry I couldn't find a solution.

Have you tried totally reconstructing the source data/chart in a new workbook?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}