Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph
Hello,
Can someone please tell me if this is indeed possible? I would like to make a graph with 2 different Y axis's. First I would like a stacked bar graph (easy on its own; the total range of this stacked graph will most likey be from 1-10). Essentially I am displaying the total number and the individually components of the stack. To accompany this, I was hoping to show with tick marks (a min and max) the cost range for implementing the number of changes in the total bar above. Thus the min and max are dependent on this number, Is this possible with custom graphs? If so, how? Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph
Rather than tick marks, how about drawing min and max lines across the
chart: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PAL" wrote in message ... Hello, Can someone please tell me if this is indeed possible? I would like to make a graph with 2 different Y axis's. First I would like a stacked bar graph (easy on its own; the total range of this stacked graph will most likey be from 1-10). Essentially I am displaying the total number and the individually components of the stack. To accompany this, I was hoping to show with tick marks (a min and max) the cost range for implementing the number of changes in the total bar above. Thus the min and max are dependent on this number, Is this possible with custom graphs? If so, how? Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph
The Min and Max will vary for each bar. Will this accomplish that? Also, I
will need to keep the axis. "Jon Peltier" wrote: Rather than tick marks, how about drawing min and max lines across the chart: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PAL" wrote in message ... Hello, Can someone please tell me if this is indeed possible? I would like to make a graph with 2 different Y axis's. First I would like a stacked bar graph (easy on its own; the total range of this stacked graph will most likey be from 1-10). Essentially I am displaying the total number and the individually components of the stack. To accompany this, I was hoping to show with tick marks (a min and max) the cost range for implementing the number of changes in the total bar above. Thus the min and max are dependent on this number, Is this possible with custom graphs? If so, how? Thanks. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph
You could try this approach:
http://peltiertech.com/Excel/Charts/...HorizLine.html No reason you can't have multiple benchmark lines in the same chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PAL" wrote in message ... The Min and Max will vary for each bar. Will this accomplish that? Also, I will need to keep the axis. "Jon Peltier" wrote: Rather than tick marks, how about drawing min and max lines across the chart: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PAL" wrote in message ... Hello, Can someone please tell me if this is indeed possible? I would like to make a graph with 2 different Y axis's. First I would like a stacked bar graph (easy on its own; the total range of this stacked graph will most likey be from 1-10). Essentially I am displaying the total number and the individually components of the stack. To accompany this, I was hoping to show with tick marks (a min and max) the cost range for implementing the number of changes in the total bar above. Thus the min and max are dependent on this number, Is this possible with custom graphs? If so, how? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Can I make a graph to be a specific size? (actual graph) | Excel Discussion (Misc queries) | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel |