Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Making Static Lines in Chart
Hi All,
I am generating a chart (Stacked Bar) where number of series is fixed (6) but number of data points vary and as a result the scale of the Y axis keeps on changing every time it is refreshed. I also have three lines on top of the chart which I need to show to define boundaries within which the data points should lie. One at the origin (coinciding with X Axis), other at 50% and the last one at -50%. My Y axis will never go beyond 100% and -100% but because the X aixs labels keep on expanding as I select more data to plot, the graph moves up and down and the lines changes their position. Is there anyway, I can keep the line static? Please help Thanks in advance Anshuman |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Making Static Lines in Chart
Hi,
Rather than draw the lines over the chart make them part of the chart by plotting them as extra series. Have a look at this page for some examples and links to other sites. http://www.andypope.info/charts/averageline.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "anshu" wrote in message oups.com... Hi All, I am generating a chart (Stacked Bar) where number of series is fixed (6) but number of data points vary and as a result the scale of the Y axis keeps on changing every time it is refreshed. I also have three lines on top of the chart which I need to show to define boundaries within which the data points should lie. One at the origin (coinciding with X Axis), other at 50% and the last one at -50%. My Y axis will never go beyond 100% and -100% but because the X aixs labels keep on expanding as I select more data to plot, the graph moves up and down and the lines changes their position. Is there anyway, I can keep the line static? Please help Thanks in advance Anshuman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making two lines into one | Excel Worksheet Functions | |||
Making first row Fixed/Static | Excel Discussion (Misc queries) | |||
Making a pivot table report static. | Excel Discussion (Misc queries) | |||
Making column reference in INDIRECT non-static | Excel Worksheet Functions | |||
Copying cell values once and then making them static | Excel Worksheet Functions |