•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to reorganize how data is displayed for easier formula use
Our take
Reorganizing your sales data for more effective formula use can significantly enhance your productivity. You're seeking to transform the data range from A1:C11 into a structured chart similar to E12:K17, enabling you to apply specific formulas without the tedious task of manually adding Sundays. This streamlined approach not only saves time but also empowers you to focus on data insights. With the right techniques, you can effortlessly achieve this transformation and make your spreadsheet experience more intuitive and efficient.
So I have been trying to figure out a way to have the sales data that I pull (A1:C11) re organize in to a chart that looks like E12:K17 but haven't had any luck. I want to use the graph from E12:K17 to do certain formulas and I would really prefer not to have to manually add all Sundays from the first chart to the corresponding column in the second chart. Any help would be much appreciated, thank you!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Rearranging data to make a line chart with multiple seriesI want to make a set of line charts with multiple series each with the following: Sampling Date is on the x-axis | SSILT63_2 (%) (or any variable from columns C-E) is on the y-axis, and each series in the chart is named after the different points in Column A. I tried selecting Columns A-C to make the first chart, but instead of making multiple series, it made a single series instead. https://preview.redd.it/jnkd63xgmcwg1.png?width=3174&format=png&auto=webp&s=9e4bcaebafddd8bbbcf875d14e53b1e87a8a83bb It works when I transpose the data with the points as different columns and the dates as the rows, but the issue then is that I have to manually arrange it, which takes a lot of time for a single variable. https://preview.redd.it/cfn4ay6jpcwg1.png?width=2682&format=png&auto=webp&s=899d24ad87eda26956b8e22f24655ec5a0f68f5e I am wondering if there is a function or feature to either: * Have Excel recognise different series from Column A in image 1 * Quickly / automatically rearrange the data from image 1 to look like the table in image 2 Edit: I am using Excel for Mac, Version 16.108 (26041219) submitted by /u/Real-Alternative-653 [link] [comments]
- Formula to re-arrange data set to be able to create a pivot table.I am looking for a formula to re-arrange the data I have: https://preview.redd.it/vkdes6wyxqrg1.png?width=345&format=png&auto=webp&s=a30397f809384603a701af85ad807c46b9bdacf4 This is the format I want: https://preview.redd.it/43zatlm0yqrg1.png?width=450&format=png&auto=webp&s=902ea4ac22cb499f567009801ba6def7766b929e I need to do this the pay data of approx. 100 employees, each employee has a different set categories so the number of times the name needs to repeat will vary. I want to do this so I can create a pivot table, any suggestions are welcome. Using Excel365 Desktop - Beginner to intermediate level knowledge Thank you in advance. submitted by /u/Ok_Chicken_590 [link] [comments]
- Trying to create a box and whisker (?) chart without the box.https://preview.redd.it/s5g40zff2mtg1.png?width=1000&format=png&auto=webp&s=093040894eed1350759891f81509ab228024aba1 The above is what I am trying to re-produce in Excel. I have the data set for each football league, and the ELO Rating for each club in that league. Column A = League Column B = Team Column C = ELO rating No matter what chart type I use, I cannot get the data to display like above. The closest I can get is 'Box and Whisker' and then tick 'Show Inner Points', but this still leaves the Box and the minimum/maximum values that I don't want. I just want the data points on their own like above. Please help. submitted by /u/LinkTheFires [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]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#rows.com#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#AI formula generation techniques#formula generator#data#chart#reorganize