Chart Help!! (1 Viewer)

L

lukea51

New member

Local time

Yesterday, 21:37

Joined

May 28, 2008

Messages

5

• Jul 1, 2008

• #1

I attached a picture of a chart that I'm trying to create. I manually created this chart using Microsoft expression design.

Is it possible to create this chart in excel?

 

Attachments

• 
  Graph Closeout.jpg

  39.5 KB · Views: 222

C

Call_Me_Sam

Chief Imperial Navigator

Local time

Today, 05:37

Joined

Feb 26, 2008

Messages

244

• Jul 1, 2008

• #2

lukea51 said:

I attached a picture of a chart that I'm trying to create. I manually created this chart using Microsoft expression design.

Is it possible to create this chart in excel?

Click to expand...

I can't actually see anyway of doing the forth 'piled up' column. i have tried a hash up of laying two charts one on top of the other..but it's a mess and won't line up..you prob tried that yourself..

 

S

shades

Registered User.

Local time

Yesterday, 23:37

Joined

Mar 25, 2002

Messages

516

• Jul 2, 2008

• #3

John Walkenbach has some samples in his book Excel Charts, chapters 7 and 8. You might want to look there.
________
New Yorker

 

Last edited: Feb 16, 2011

S

shades

Registered User.

Local time

Yesterday, 23:37

Joined

Mar 25, 2002

Messages

516

• Jul 2, 2008

• #4

I checked in that book I mentioned in the post above. If you look at pages 256-257 and modify the setup you will get exactly what you want. I had setup something like that about a year ago. Note, rather than use blanks for no data in those columns that have only one stack, it would be better to use =NA() to produce #N/A which will not be plotted.
________
MICHIGAN DISPENSARIES

 

Last edited: Feb 16, 2011