Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how to plot an infinity point in Excel


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: how to plot an infinity point in Excel

Unfortunately, it is not possible to plot an infinity point in Excel as infinity is not a numerical value that can be represented in a cell. However, you can use a workaround to visually represent an infinity symbol in your Excel worksheet. Here's how:
  1. Select the cell where you want to insert the infinity symbol.
  2. Go to the Insert tab in the ribbon.
  3. Click on Symbol in the Text group.
  4. In the Symbol dialog box, select Arial Unicode MS as the font.
  5. Scroll down until you find the infinity symbol (it should be near the bottom).
  6. Click on the infinity symbol to select it.
  7. Click on the Insert button to insert the symbol into the selected cell.
  8. You can now format the cell to adjust the font size, color, and alignment to your liking.

Note that the infinity symbol will not have any numerical value, so you cannot use it in calculations or formulas. It is purely a visual representation.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 348
Default how to plot an infinity point in Excel

Can't do it! Excel won't handle infinity as a number.

One workaround is to put a very large number in the cell that is
supposed to represent infinity, but then your data plot is going to be
very compressed.

Bill
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Point labels in an Excel scatter plot to be associated text Point labels in scatter plot - text? Charts and Charting in Excel 4 April 29th 23 07:45 PM
Scatter Plot Point Labels Dallas Excel Worksheet Functions 2 December 5th 07 03:24 PM
How do I plot a trendline that goes through a specified point? triplej80 Charts and Charting in Excel 2 February 7th 06 09:45 PM
Retrieve point address from scatter plot by clicking? Jdoggrr Charts and Charting in Excel 3 October 21st 05 02:02 PM
scatter plot & label for a data point shabnam Charts and Charting in Excel 3 April 11th 05 06:37 PM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"