Powerpoint 2007 2-D Column Question 2

[MattGreer]

I have some data to compare. I wanted to use side-by-side columns. When I select 'Display on Secondary Axis' for one of the data sets, it takes the columns and overlaps them completely. When I go into the settings to try to separate the columns and remove the overlap it makes no difference.

How can this be changed/stopped/fixed?

Thanks!!


Matt

 

[xlhelp]

Matt,

I no unnerstand why you plotting on Secondary axis.

Why can you not put the data side by side and plot it that way? Or is there another reason?

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[MattGreer]

You know, I realized that this is actually an Excel question. Perhaps I should re-post it.

I have two columns of data. In other words, I have two results for each experiment. The scales are completely different. One result is on the order of 0.003 to 1.2 and the other is 50 to 420. So putting them on the same scale would be just plain stupid. You wouldn't be able to see the small results.

I should re-post this, dontcha think?

Thanks!!


Matt

 

[SkipVought]

If this is Excel, and NOT the klunky graph that you get in Power Point, then check out the Data Series > Options TAB -- GAP & OVERLAP

Skip,

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

 

[xlhelp]

Try skewing you data like this, and then plot:
[blue][tt]
Jan 2
[tab]62
Feb 5
[tab]47
Mar 3
[tab]61
Apr 7
[tab]72
May 4
[tab]83[/tt][/blue]

And select the lower series as the Secondary axis.
BTW, it's always a good idea to post as much information as you can, so peole like me don't ask silly questions.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[MattGreer]

Skip,

Create a two bar chart, and put the 2nd bar on the second axis. No matter how you set the Series Overlap and Gap Width, they are still covering each other. There must be a setting somewhere else, but it escapes me.

xlhelp, that's the most screwed up thing I've ever seen. And it works. You are my new graphing buddy. Thank you!

It's going to make preparing the data a pain in the butt but it works.

Thanks!!


Matt

 

[xlhelp]

Actually, manipulating the data is not so difficult either.

First,(taking chances at getting my wrists slapped),look at this thread: thread68-1580102

Then highlight a series and move it one cell down.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[SkipVought]

Works for me. You must have 1 empty series on primary and 2 empty series on secondary. Check the Source Data --Series TAB to be sure that you have TWICE as many series defined as there are columns with data.

Skip,

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