•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Convert raw data to layout
Our take
Are you frustrated with manually formatting reports from raw data? Imagine transforming your Excel tables into polished reports with a fixed layout, all while adapting seamlessly to changes in your data. With the right approach, you can automate tasks like transposing columns, drawing graphs, and inserting titles and constant data for limit lines. This means less time wrestling with spreadsheets and more time focusing on insights. Read on to discover how to streamline your reporting process and unlock the full potential of your data.
hi there,
I would want to know if it's possible to convert "raw" data from a table (or multiple) from a sheet into a report with a fixed layout I'd have made (like a model for graphs) in an automated way, would be better if it could adapt to small changes like number of rows for example.
it would for example :
-transpose columns A to E but keep a unique value for each one out of a table, in separate rows - draw graphs of G and H knowing F - add a big title - insert constant data to draw limit lines
Excel 2016 for now
See pictures in comment
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Hot folder data sorting.My goal is to create a hot folder that I am able to continuously drop data sheets into. Then have excel transfer a few specific cells ie.( totals, names )into a uniform row on a new table/sheet. •all data sheets will be formatted the exact same and information will be in the same positions across all of them •data sheets will be added daily •each data sheet needs to create its own respective line representing information from only that sheet •some of the cells needed are a result of total formulas in the data sheet •no information besides the specific cells should reflect in the new table (Photos in comments) P1- example of the data sheets used with the cells circled that are wanted to be transferred. P2- example of what it should somewhat look like when presented in the table/sheet submitted by /u/Notsuspicious444 [link] [comments]
- 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]