If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Plotting Pos / Neg #'s
I have a series of graphs that would be similiar to below:
Bar 1 plot: 0 to 6,000 Bar 2 plot: 4,000 to 6,000 (to show drop of 2k) bar 3 plot: 4,000 to 5,000 (to show gain of 1k) Bar 4: would like to show -1,000 to 5,000 (to show drop of 6k) I can plot 0 to 5k or 0 to -1, but can not get it to post a bar showing a postive & negative. (-1 to 5 I would appreciate any ideas. |
#2
|
|||
|
|||
Plotting Pos / Neg #'s
JB -
See if this example is any help: http://www.geocities.com/jonpeltier/...eAndBelow.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ JB wrote: I have a series of graphs that would be similiar to below: Bar 1 plot: 0 to 6,000 Bar 2 plot: 4,000 to 6,000 (to show drop of 2k) bar 3 plot: 4,000 to 5,000 (to show gain of 1k) Bar 4: would like to show -1,000 to 5,000 (to show drop of 6k) I can plot 0 to 5k or 0 to -1, but can not get it to post a bar showing a postive & negative. (-1 to 5 I would appreciate any ideas. |
#3
|
|||
|
|||
Plotting Pos / Neg #'s
On Thu, 9 Oct 2003 09:10:38 -0700, JB wrote:
I have a series of graphs that would be similiar to below: Bar 1 plot: 0 to 6,000 Bar 2 plot: 4,000 to 6,000 (to show drop of 2k) bar 3 plot: 4,000 to 5,000 (to show gain of 1k) Bar 4: would like to show -1,000 to 5,000 (to show drop of 6k) I can plot 0 to 5k or 0 to -1, but can not get it to post a bar showing a postive & negative. (-1 to 5 Jon to the rescue: http://www.geocities.com/jonpeltier/...ngColumns.html ---- Dave dvt at psu dot edu |
#4
|
|||
|
|||
Plotting Pos / Neg #'s
I think I know what you are talking about. It's like a
stock chart with high and low values, but in bar format. I tried your scenario with a stacked bar chart, which i then modified, choosing "no fill & no border" and then dragged some of the labels around. Looks professional. try it... -----Original Message----- I have a series of graphs that would be similiar to below: Bar 1 plot: 0 to 6,000 Bar 2 plot: 4,000 to 6,000 (to show drop of 2k) bar 3 plot: 4,000 to 5,000 (to show gain of 1k) Bar 4: would like to show -1,000 to 5,000 (to show drop of 6k) I can plot 0 to 5k or 0 to -1, but can not get it to post a bar showing a postive & negative. (-1 to 5 I would appreciate any ideas. . |
Thread Tools | |
Display Modes | |
|
|