•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Create scatter plot that changes colors based on value?
Our take
Are you looking to enhance your tracking system for past due customers? Creating a scatter plot that automatically changes colors based on value can provide clear visual insights into your data. By assigning specific colors to different ranges of past due amounts, like Light Green for 1,001 to 1,500, you can easily identify trends at a glance. This guide will walk you through the steps to set up your scatter plot, ensuring it dynamically reflects your current data.
Hi again all,
I'm trying to create a tracking system of our past due customers. I'm creating daily data that fits these catgegories as follows:
Dark Blue: 0-500
Light Blue 501-1000
Dark Green 1001-1500
Light Green 1501-2000
Yellow 2001-2500
Orange 2501-3000
Red 3001+
So today, we had 1070 Past Due Customers. I'm trying to create a scatter plot based on my data that will automatically color this point Light Green, as it fits within that range.
Tomorrow if we somehow have 3500 past due customers, I'd want that point to be red. My sample isn't cutting it.
Any tips/advice? (Yes, I know my date axis is a mess, it's all in progress)
Sample data below:
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Issue with plotting on graphs?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! 🙏 submitted by /u/Jack_The_Pinapple [link] [comments]
- 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]
- How do you vary colors of bar graph by day of the week?I feel really stupid for this because I am searching all over and not seeing answers for this. Like is this a basic option I am missing that is so obvious nobody asks it? Basically I have a bar graph for data points throughout the year, I want something like Mondays red, tuesdays blue, wednesdays green, etc etc The option to "vary colors by point" seems to alternate every 14 or so colors and there doesn't seem to be a way to change the interval, that I can tell. Obviously I can manually change colors but this is excel and there has gotta be a way to alternate that rather than do it for each individual point. Especially since I have multiple "yearly" charts I'd like to do this for. submitted by /u/machinelock [link] [comments]
- how can I change the color of lines related to future speculations to highlight them from what has already happened?My graduation thesis will show the evolution of a certain index of a company, and also a forecast of how it will behave in the future. I would like to know if there is a way to change only specific segments of lines in a single chart. submitted by /u/One-Lettuce-1404 [link] [comments]
Tagged with
#Excel alternatives for data analysis#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#rows.com#cloud-based spreadsheet applications#Excel compatibility#scatter plot#past due customers#color coding#tracking system#customer tracking#color range#daily data#automated coloring#data categories#color threshold#data visualization