Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to get excel to recognise "infinity" for asymptotes in charts
I'm trying to make various graphs based on the function "y = tan(x)" for
revision purposes. The only problem is that the graph contains an asymptote: a dotted line parallel to the y-axis that the plot-line approaches but never quite reaches. Excel doesn't seem to recognise this and I don't know how to make it deal with asymptotes. In other words, the asymptote represents a value of +-infinity. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to get excel to recognise "infinity" for asymptotes in charts
XL doesn't understand the concept of an asymptote or of infinity. So, the
best one can do is create the appropriate visual effect. See More information about PLOT http://www.tushar- mehta.com/excel/software/plot_manager/decompiled_help/plot6.html and particularly Comparing the graph of Tan(x) drawn with the Plot Manager and an Excel table http://www.tushar- mehta.com/excel/software/plot_manager/decompiled_help/plot6.html#Compare% 20Tan Watch out for line breaks in the URLs. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , ?B? Sm9leSBKdWJi?= <Joey says... I'm trying to make various graphs based on the function "y = tan(x)" for revision purposes. The only problem is that the graph contains an asymptote: a dotted line parallel to the y-axis that the plot-line approaches but never quite reaches. Excel doesn't seem to recognise this and I don't know how to make it deal with asymptotes. In other words, the asymptote represents a value of +-infinity. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to get excel to recognise "infinity" for asymptotes in cha
Thank you very much! I wonder if MS Student can work with Asymptotes?
"Tushar Mehta" wrote: XL doesn't understand the concept of an asymptote or of infinity. So, the best one can do is create the appropriate visual effect. See More information about PLOT http://www.tushar- mehta.com/excel/software/plot_manager/decompiled_help/plot6.html and particularly Comparing the graph of Tan(x) drawn with the Plot Manager and an Excel table http://www.tushar- mehta.com/excel/software/plot_manager/decompiled_help/plot6.html#Compare% 20Tan Watch out for line breaks in the URLs. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , ?B? Sm9leSBKdWJi?= <Joey says... I'm trying to make various graphs based on the function "y = tan(x)" for revision purposes. The only problem is that the graph contains an asymptote: a dotted line parallel to the y-axis that the plot-line approaches but never quite reaches. Excel doesn't seem to recognise this and I don't know how to make it deal with asymptotes. In other words, the asymptote represents a value of +-infinity. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert excel charts as objects | Charts and Charting in Excel | |||
insert excel charts as objects | Excel Discussion (Misc queries) | |||
Overlay charts in excel | Charts and Charting in Excel | |||
Excel should be able to do log to base 2 charts | Charts and Charting in Excel | |||
EXCEL Hyperlink to Charts Questions.. URGENT.. =( | Excel Discussion (Misc queries) |