Excel Graphing & Trend Analysis
Budget: €8 – €30 EUR
I have a dataset that needs to move beyond raw numbers into clear, visual insights. Using Microsoft Excel’s descriptive-statistics tools, I want two things:
• Dynamic bar and line charts that instantly update when the underlying data changes.
• A concise analysis pinpointing seasonal trends and flagging any outliers or anomalies you uncover.
I’ll provide the workbook and indicate the key variables to plot. Your charts should follow best-practice formatting—clean axes, legible labels, and color schemes that print well in gray scale. For the analysis, please include a short narrative and, where useful, embed simple statistical measures (mean, standard deviation, coefficient of variation) to support your findings.
If formulas, named ranges, or pivot tables make maintenance easier, feel free to build them in; just document what you do so I can follow the logic later.
• Dynamic bar and line charts that instantly update when the underlying data changes.
• A concise analysis pinpointing seasonal trends and flagging any outliers or anomalies you uncover.
I’ll provide the workbook and indicate the key variables to plot. Your charts should follow best-practice formatting—clean axes, legible labels, and color schemes that print well in gray scale. For the analysis, please include a short narrative and, where useful, embed simple statistical measures (mean, standard deviation, coefficient of variation) to support your findings.
If formulas, named ranges, or pivot tables make maintenance easier, feel free to build them in; just document what you do so I can follow the logic later.