Chart (Excel 2000)

Topic

New Reply

Hi Gurus,

How can I plot a bar chart which has two different series of vastly different values. I have attached the data file.

Thanks in advance.
Novice excelite

Reply | Quote

Replies

This can be done by reorganizing the data slightly and by plotting the thrid and fourth series on the secundary axis, so that they can use a different scale.

Reply | Quote

Thanks Hans,

That was marvelous. Can you tell me how to go about charting it so that I can make some more charts.
Rgds
Novice

Reply | Quote

Here are some websites that provide a lot of examples of charting techniques:

AJP Excel Information – Charts
Peltier Technical Services, Inc.

and a web page listing more links:

Contextures — Excel Chart Links

Reply | Quote

Hi Hans,

Thanks for the info. As I am in a bit of hurry can you pinpoint which method you used to help me out.

Rgds
Novice

Reply | Quote

I was away from my PC, so I hope this isn’t too late. See Creating a Clustered-Stacked Column Chart.

Reply | Quote

P.S. The link has changed to a new location : . Thanks so much, Hans, I knew you would know the answer to this! Thank goodness for Woody’s Lounge searches.

Reply | Quote

You’re welcome. But I’m confused – your link points to the same URL as mine.

Reply | Quote

Sure does… But when I was clicking your link before, it was taking me to the dreaded Page Cannot Be Found. Now it’s working fine though. Go figure, perhaps there are strange cosmic rays about!

In any case, THANK YOU for pointing me to the right answer without even being asked.

Reply | Quote