|
I have a table of numbers on a spreadsheet, let's say, 10 rows and 12 columns.
I want to draw a line in diagonal from left bottom corner to right top corner.
How can I do that? (not do it on a chart)
in Excel version 5.0, it has such function to draw a trendline directly on this table.
diligent hands rule....
|
|
|
|
|
1.) Maybe not the right place to ask that. Anyway don't care too much about that
2.) Quote: 'How can I do that? (not do it on a chart)'
When not in a chart, where else?
3.) Quote: 'in Excel version 5.0, it has such function to draw a trendline directly on this table.'
Now we are back in a chart, right? Where a trend line can be shown other than in a chart?
4.) Trend line exists also in the current version of excel.
5.) 10 rows and 12 columns means something like 11 functions. What is your idea to get _one_ trend over 11 functions?
Only my two cents 
modified 7-Jan-23 11:41am.
|
|
|
|
|
my question comes from an old investment book and it used old terms in Excel version 5.0.
So I assume only gurus might know this answer...
diligent hands rule....
|
|
|
|
|
I'm sure I'm pretty save with excel and trend lines what else  
|
|
|
|
|
wrong forum.
wrong forum.
wrong forum.
wrong forum.
wrong forum.
wrong forum.
|
|
|
|
|
Without answering, as this is the wrong forum, here's a hint. You want to draw a line? In Excel 2003 (the latest version I use) there's a Drawing toolbar. You might find an equivalent "ribbon" but as you've not said what version you're using, we can't really advise further. 
|
|
|
|
|
thanks for your info! it is worthy for me to post here to get your answer
BTW: based on your hint, I found what I want. it is not exactly as a drawing trendline function. actually it turns into another object...
diligent hands rule....
|
|
|
|
|
when you answer these types of question in the bloody Lounge, you encourage more of this. 
|
|
|
|
|
It's not exactly a programming question. It's no different really than The Lounge[^] or The Lounge[^].
(And it's not even like there's an Excel CP forum to ask it in)
|
|
|
|
|
I actually don't care, personally.
However new members come here all the time in the Lounge and they get scorched, burned, and sometimes humiliated by other members on the site for even attempting to ask a technical (not programming) or programming question.
However, existing, and sometimes veteran members get away with it here, because of course, why the bloody hell not.
Excel questions are a technical question, and they belong in Q and A and not in the Lounge.
|
|
|
|
|
Out of genuine curiosity, and no intent to be obtuse, which forum would you suggest? I've been here over 13 years but wouldn't know where to ask an Excel question... Doesn't fit in any of the other places I can see, and if I were to ask this question in (say) General Programming / COM I'd get told to move it elsewhere as it's not COM; it's not VBA, it's not database etc.. etc.. Even the forums list page[^] doesn't mention either Excel or Spreadsheets
|
|
|
|
|
there is no forum for excel.
no forum
that is what Q & A is for: https://www.codeproject.com/Questions/ask.aspx[^]
My entire point in all of this is that if we allow the OP to post excel questions in the Lounge, then we need Chris to change the rules for the Lounge and let ALL users ask technical and programming questions in the Lounge. It's that simple.
|
|
|
|
|
101 points!
(for getting pigeon-holed and the feathers on the left side of your refrigerator tape ruffled)
|
|
|
|
|
#Worldle #350 3/6 (100%)
🟩🟩🟩🟩⬜↙️
🟩🟩🟩🟨⬜⬆️
🟩🟩🟩🟩🟩🎉
https://worldle.teuteuf.fr
Did not have to use map
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Wordle 567 4/6
⬛🟨⬛⬛🟨
⬛🟨🟨⬛⬛
⬛⬛🟨🟨⬛
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 567 5/6
⬛⬛⬛🟨🟨
🟨🟩⬛⬛⬛
⬛🟩⬛⬛🟩
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 567 3/6
⬜⬜🟨⬜🟨
⬜🟨⬜🟨🟩
🟩🟩🟩🟩🟩
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Wordle 567 5/6
⬜⬜⬜🟨⬜
⬜⬜🟨⬜⬜
🟩🟩⬜⬜⬜
🟩🟩⬜⬜⬜
🟩🟩🟩🟩🟩
|
|
|
|
|
⬜⬜⬜🟨🟨
🟨🟨⬜⬜⬜
⬜🟩🟨⬜⬜
⬜🟩🟨🟩🟩
🟩🟩🟩🟩🟩
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Wordle 567 3/6
⬛🟨🟨🟨🟨
🟨🟩🟨🟩🟩
🟩🟩🟩🟩🟩
I got lucky on the first word!
Get me coffee and no one gets hurt!
|
|
|
|
|
Wordle 567 3/6
⬜🟨⬜⬜🟨
🟨🟨⬜🟨🟨
🟩🟩🟩🟩🟩
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
|
Those were the days... I had pretty much every AUTOEXEC.BAT & CONFIG.SYS command memorized. I felt like a wizard! Friends, family or neighbors would call with a problem (  ), I'd show up, open those two files, make wholesale tweaks and reboot. Voila!
Until they installed the next piece of crappy software and the process repeated. x 2.
|
|
|
|
|
I remember the sounds in the days Before Sound-Blaster. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
I also remember the fun and games tuning AUTOEXEC.BAT and CONFIG.SYS to get mouse and SB loaded and still have enough ram left to play the game ... I forget how many different boot floppies I had, but it was most of a box.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: I remember the sounds in the days Before Sound-Blaster
There's not much in terms of SoundBlaster predecessors, except maybe for the Adlib. I remember Sierra's magazine used to promote it rather heavily and I spent...well, I don't remember exactly how much, but it was a lot of money even back then for what you got, especially considering I was still in school. It improved their games a lot, but still, in hindsight...eeeek.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)