•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Issue with plotting on graphs?
Our take
Are you struggling with plotting your data accurately on a scatterplot? You’re not alone. It sounds like you're encountering an issue where your intended x-axis values, ranging from 0 to 50 in intervals of 5, are being replaced with a different scale. This common challenge can be frustrating, but with the right adjustments, you can ensure your data is represented as intended. Let’s explore some solutions to help you regain control of your graph and effectively visualize your data. Your insights deserve to shine.
So I have a set of data that needs to go from 0-50 in intervals of 5 on the x-axis, but go some reason each time I create the scatterplot it ignores the fist column with those numbers, and switches them for 0-14 in intervals of 1 or 2. I can’t figure out what to do. Please help me! Thanks! 🙏
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Stacked scatter plot with same y-axis for readabilityIm working with SCADA and pulling together data from a model to compare the 2 at a couple of different locations. Is there a way to stack 3 graphs in excel without completely manually doing it? the data is all for the same week in sub minute increments, so needs to be a scatter plot. and y-axis is all the same so its not a like a secondary axis is beneficial in this case. below is the plots with all the data, very hard to parse unless someone explains what's going on. https://preview.redd.it/cgyalit9wyzg1.png?width=1426&format=png&auto=webp&s=b03a3d9022a3efc482d6d3161a52186c1c745f36 below is what I'd like the graphs to look like, done in ppt. Kind of annoying to do manually and there's a couple of other locations I need to do this for, so if there's a better solution, let me know! https://preview.redd.it/9003h0vwvyzg1.png?width=848&format=png&auto=webp&s=e5af1d78cde58175ed5451fbb4e85f06a4f89815 submitted by /u/MyGoddamnFeet [link] [comments]
- Making series specific categories on a box and whisker plotI am trying to make a box and whisker plot from a dataset with four series and many categories. Each series has its own unique categories. When I plot each series individually, the box and whisker plots look fine, but when I plot them together they get really squished. I found out that Excel plots each series as though it has data for each category, instead of its own set of categories. This makes the resulting boxes look really squished. I filled in some blanks with 0's to understand what was going on. https://preview.redd.it/7bzp08tnhp0h1.png?width=1579&format=png&auto=webp&s=147114c253d508a82fc0c86b83ed2362a6dada5d Is there a way to plot these different series together so that each of them has its own separate set of categories? submitted by /u/Real-Alternative-653 [link] [comments]
- Custom error bars excel problemSo I have data for a project that I made into a line chart, which took me almost 4 hours because of the fact that excel didn't want to take my data as It was, it would see it as zero's instead of normal decimal numbers. After troubleshooting that I have another problem. I have the line graph I only need to add my custom error bars. The numerical value of the numbers should be big enough to show up, but excel just doesn't want to add them. I am selecting the range and everything correctly, I've tried with completely different numbers, different graphs and converting them etc nothing works. Please help me troubleshooting I am going insane. submitted by /u/alt_bc_im_a_pussy [link] [comments]
- help me understand graphs (school assignment)https://preview.redd.it/bfro8i86sxwg1.png?width=1186&format=png&auto=webp&s=0ad03964903444767814bd9306ce52db861261e5 hello, im doing a school assigment where i need a graph and everytime i highlight my data and press "insert chart" it becomes this mess on the side and ove tried looking up how to make grpahs and it isnt working, plese help submitted by /u/memermonkey [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#rows.com#financial modeling with spreadsheets#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#Excel compatibility#intelligent data visualization#real-time collaboration#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#scatterplot#data#intervals