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
|
|||
|
|||
Need a special bar graph
Hello,
I want to represent the birth and death of several historical figures in a horizontal line graph, given the birth and death dates. For example, consider the following. Pericles, -495 to -429 Socrates – 469 to -439 The graph I have in mind is somewhat like a Gantt chart. The graph techniques that I see in Excel only allow for one point, and always reference zero. What would you suggest for a graph of these? Thank you, Keith |
#2
|
|||
|
|||
Need a special bar graph
Here is my data (I do wish we had a better way of showing data!)
born died Pericles -495 -429 Socrates -469 -439 Archimedes -289 -212 Pericles -429 -66 Socrates -439 -30 Archimedes -212 -77 The word "born" is in B1; the second "Pericles" is in A7 In B7 I have =c2 and in C7 I have =B2_C2 These formula are copied down the to row 9 Make a stacked bar chart (the middle sub-chart option - not the 100% option) Format the first series to have no fill and no lines Format the horizontal axis to cross the vertical axis at -600 Get my email address form my website and send me a message and I will forward a file to you -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Keith" wrote in message ... Hello, I want to represent the birth and death of several historical figures in a horizontal line graph, given the birth and death dates. For example, consider the following. Pericles, -495 to -429 Socrates - 469 to -439 The graph I have in mind is somewhat like a Gantt chart. The graph techniques that I see in Excel only allow for one point, and always reference zero. What would you suggest for a graph of these? Thank you, Keith |
#3
|
|||
|
|||
Need a special bar graph
Hi Bernard,
I got it to work. Thanks very very much. Keith |
#4
|
|||
|
|||
Need a special bar graph
You are very welcome
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Keith" wrote in message ... Hi Bernard, I got it to work. Thanks very very much. Keith |
Thread Tools | |
Display Modes | |
|
|