•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why are my plotted graphs coming out different?
Our take
If you're encountering issues with your plotted graphs in your chemistry report, it's likely due to how the data series are being interpreted in your charting tool. When you select cells B3 to B6 for the x-axis and D3 to D6 for the y-axis, ensure that you're not inadvertently creating separate data series. To achieve a single line chart, try selecting both sets of data together, ensuring they are correctly linked.
Currently doing a chemistry report. For my x-axis I want to have cells B3,B4,B5,B6, with the axis title called 1/K, and my y-axis to have D3,D4,D5,D6 with axis title ln(Kx). But when I highlight these cells and click insert Line with markers chart is shows me 2 separate lines one for 1/k and another for ln(kx), but I just want 1 single line, I did this in the past with another line chart in which I used Time and Temperature and got a single line but now doing the same thing this happens. Any help?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Trying to do a line graph but it only displays one valueHey guys, so I'm trying to do a line graph in excel. Basically I have 3 groups, two intervention groups and one control group. In each group are about 20 people. There are three measurement points across 15 months. I am now trying to display the progress/change of each single person across those measurement points. So like 20 lines beneath each other and one line displays one person. Problem is, when I mark the values (which I imported from SPSS) and insert a line graph it shows me one single point in it and every value in my spreadsheet is inserted as an axis label and not as a value in the graph. And also suddenly only one line and one column is marked. What am I doing wrong? How do I make it into an adequate graph? More info: I am a beginner, my Excel is set to German, i am using a windows pc and the version is 2601. https://preview.redd.it/dhqvj3wykchg1.png?width=632&format=png&auto=webp&s=bf20caf1ff916ee68fac147bdf4c2cbc78f1beeb submitted by /u/Resident_Recording70 [link] [comments]
- Incorrect X Y PlottingHello! Having a problem with my excel graph, I've inserted the screenshots below, as it's not plotting my values as actual plots , but instead keeps them on the x-axis? They should be dotted across the graph. The ranges for the x and y axis seem to be correct though. Any advice/ pointers will be greatly appreciated. I'm assuming this is quite a common problem as I've seen other google searches and posts about this, but just struggling to get through their instructions/ advice. https://preview.redd.it/4pg7u8axwnlg1.png?width=908&format=png&auto=webp&s=043b32c23830be70c9c10738b61480ee760adaaa https://preview.redd.it/qa9rro36xnlg1.png?width=387&format=png&auto=webp&s=6b49d335345cc600d6784b7a9e1c8c5e9ad82594 https://preview.redd.it/ruwr9hv7xnlg1.png?width=378&format=png&auto=webp&s=fe30737040cd51f6908a7dc49f0ed5b1f9bf8efb submitted by /u/Important-Tank9247 [link] [comments]
- How to make Line Charts automatically not start from 0?Hi guys, I am working on a calculator made in excel. It pulls the data from one sheet and in another one it displays some kpi summaries, insights and line charts. I am not happy with how the line charts look like because it always starts from 0 and my line is sitting on the top third of the chart, while the bottom two thirds are just empty space. I tried a few things, such as adding helper columns in the chart and making them invisible, to automatically adjust it every time new data is uploaded but the min is always 0 and I have control over the max only, which lowers the position of the line but makes it even more straight so it's still unappealing. I do not want to use VBA as it's something we are sending to clients, and if they do not enable macros then it's for nothing. Are there any solutions you guys might know? I am using the desktop version of excel, on mac. Thank you submitted by /u/Think_Jello_8525 [link] [comments]
- Why are the Y Axis Values not being plotted Correctly?I currently have a line chart that is not plotting correctly. I would like the value of 34.5 to match the value shown on the Y Axis, currently they are not aligned. What am I missing here? https://preview.redd.it/1mf9dnunafrg1.png?width=1781&format=png&auto=webp&s=0ae3e2f8c4048175fa13c3ab435ec72aedbb2259 submitted by /u/Engineer0117 [link] [comments]
Tagged with
#Excel alternatives for data analysis#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#real-time data collaboration#real-time collaboration#Excel alternatives#chemistry#report#x-axis#y-axis#line chart#single line#1/K#ln(Kx)#markers#plotted graphs#B3