Not sure the right way to name this so possible the answer is already out there and I didn't search the right terms.
Working on a financial forecasting sheet where the rows are various data points and the columns are months (for a 10 year span). Rows ~5-15 get some manual input data and projections each month, rows ~17-27 run some calculations on row 5-15 data. Below row ~30 I would like to build a chart that tracks the data points on the chart aligned with the column where the data comes from (IE May 2023 point on the X-Axis aligns with the May 2023 column of data). Is this possible to get it to align? For simplistic examples, it would be stuff like monthly revenue vs monthly cost on a line chart.
I know I could do this statically by resizing the chart to line up the way I want, but a couple concerns there:
1) Each month we will make a new copy of the sheet and drop off the first month in 10-year span and add a month to the back end
2) construction co, so we have multiple projects which will each have their own identical tab in the workbook but whose data may span different time frames (one project might be may 23-aug 23, one could be June 24-Oct 28, etc) so every chart would need to be specially sized. It would also need to be re-sized if the project lengthened shortened
3) I don't think you can freeze-pane the axis labels, so as you scrolled right you would lose the y-axis if you were in the middle of a 50 cell-wide chart
Is something like this possible? Eventually I hope to get something a bit more sophisticated with some data visualization going for this task, but for now we need to start somewhere.
Thanks,
Bookmarks