How does one attach an image to this window?
I see the ''attach'' in the icon bar at the top, but cannot figure out how to use it.
How does one attach an image to this window?
I see the ''attach'' in the icon bar at the top, but cannot figure out how to use it.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks AliGW
The two attachments show that the first point on a graph to be plotted is designated to be X=0 & Y=$100,000.
However, the point is actually plotted at X=1 and not X=0 ? Please advise.
It is difficult to debug from a picture. An actual Excel file would be more useful.
The first thing I would look for is any text or numbers stored as text in B20:B29. If there are any numbers stored as text, or any other text strings in that range, convert those values to meaningful numbers.
Originally Posted by shg
Thanks MrShorty.
The Excel program is attached [I hope].
When I opened your file, the first thing I noticed was a little green triangle "error indicator" on B20. The error indicated is number stored as text. I checked the number formatting for B20, and it is formatted as text @. My recommendation would be to format B20 so that it is a number and not text (maybe format as integer like the cells below or format as general). Then re enter the number 0 into B20 so that B20 will contain the number 0 and not the text string "0".
Many thanks MrShorty,
That was exactly right-on, & the problem is fixed.
Much appreciated.
Many thanks MrShorty,
That was exactly right-on, & the problem is fixed.
Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks