Jump to content

Excel graphing

Mo5
By Mo5
in Operating Systems
 Share
Posted

I have this basic graph(s) made in Excel and it's cool and all, but there's one "small" problem. The difference between 2 points of data (x axis) isn't constant. Is it possible to extrapolate data in between and somehow make the graph more accurate. I hope you understand what I mean :)

 

BlhyNj9CIAAyp1X.jpg

Asrock 890GX Extreme 3 - AMD Phenom II X4 955 @3.50GHz - Arctic Cooling Freezer XTREME Rev.2 - 4GB Kingston HyperX - AMD Radeon HD7850 - Kingston V300 240GB - Samsung Spinpoint F3 1TB - Chieftec APS-750 - Cooler Master HAF912 PLUS


osu! profile

Link to comment
https://linustechtips.com/topic/141482-excel-graphing/
Share on other sites
Link to post
Share on other sites
Posted

You want the x axis to be the same on both? Like the y axes are? You can right click on the axis and tell it to use your own scale. If that is what you mean?

Rig: i7 13700k +Contact Frame - - Asus Z790-P Wifi - - RTX 4080 - - 4x16GB 6000MHz - - Samsung 990 Pro 2TB NVMe Boot + Main Programs - - Crucial P3 2TB NVMe for photo work - - Corsair RM850x - - Sound BlasterX EA-5 - - Corsair XC8 JTC Edition - - Corsair GPU Full Cover GPU Block - - PTM 7950 - - XT45 X-Flow 420 + UT60 280 rads externally mounted - - EK XRES RGB PWM - - Fractal Define S2 - - DellAlienware AW3423DWF 34" -- Logitech Pro X Superlight - - Logitech G710+ - - LTT Northern Lights Deskpad

 

Headphones/amp/dac: Schiit Bifrost Multibit - -  Schiit Lyr 3 - - Fostex TR-X00 - - Sennheiser HD 6xx

 

Homelab/Media Server: Proxmox VE host - - 512 NVMe Samsung 980 RAID Z1 for VM's/Proxmox boot - - Xeon e5 2660 V4- - Supermicro X10SRF-i - - 128 GB ECC 2133 - - 10x8TB WD Red RAID Z2 - - 2x 800 GB SAS SSD’s (1 SLOG, 1 L2Arc) - - 45 HomeLab HL15 15 Drive 4U - - Corsair RM650i - - LSI 9305-16i HBA - - TreuNAS + many other VM’s

 

Unifi UDM Pro in front of full unifi network infrastructure

 

iPhone 17 Pro - - MacBook Air M3

Link to comment
https://linustechtips.com/topic/141482-excel-graphing/#findComment-1889099
Share on other sites
Link to post
Share on other sites
Posted

You can make the graph more accurate if you add more data points.

But if you can't get more data then there is no good/easy way to make it more accurate.

You could change the method you're using for interpolation. However I haven't used Exel for this, so I can't really help you with that.

Generally the best method is spline-interpolation.

Link to comment
https://linustechtips.com/topic/141482-excel-graphing/#findComment-1889157
Share on other sites
Link to post
Share on other sites
Posted

Problem is that you are using two different datasets. If you want those line to be at same pace, you need to put them in same dataset as individual sets. Like date/time in collumn1, first line in collumn2 and second line in collumn3. This could be only for graphs and in different tab if it makes your organizing better. Another option it to set x axis to have same time/date markings or someother markings that are same in every dataset.

^^^^ That's my post ^^^^
<-- This is me --- That's your scrollbar -->
vvvv Who's there? vvvv

Link to comment
https://linustechtips.com/topic/141482-excel-graphing/#findComment-1892215
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Operating Systems

×