Excel Stacked Bar Multiple Column Axis Chart 1

[akrshaw]

Good Morning!~

I have everything setup fine...my only issue is...

NBR Task Start Duration
1 Enter 1 3
2 Fuzzy 2 4
3 Stop 3 6

When I chart it the NBR text is Vertical AND it Skips every other number...the Task shows next to it and is horizontal but shows every Task it does not skip...

I am beyond knowing what to do to fix it???

Thanks soooo very much!~

 

[GlennUK]

What are you expecting to see in your chart exactly?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

hi,

There is an option in the format for the category axis.

Skip,

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

 

[akrshaw]

To answer question...I want to see every number....not everyother number...and I want it horizontal...not vertical...

BUT I would just settle for seeing each number...

Skip...I think I have tried every checkbox and option inside that axis...no luck?

 

[SkipVought]

On Axis option...

Interval between label is either Automatic or explicit!

Skip,

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

 

[akrshaw]

Right...it is automatic...which shows me everyother number...but every task...on the same line..

1 Start
Fuzzy
3 Foot
Razzle
5 Boot

If I chage it to specify interval unit...it gets rid of every other task line...

1 Start

3 Foot

5 Boot

 

[SkipVought]

I extended your data to 27 rows and inserted a stacked column chart.

The AUTOMATIC result is...
[tt]
1 Start
Fuzzy
3 Foot
Razzle
5 Boot

[/tt]
The Specific Interval of 1 result is...
[tt]
1 Start
2 Fuzzy
3 Foot
4 Razzle
5 Boot

[/tt]
becaue I chose to enter the specific value of ONE.


Skip,

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

 

[akrshaw]

That is not what happens when I put one in...it does:

1 Start

3 Foot

5 Boot

So, I am getting the opposite results...?