•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Dual y-axis and overlapping x-axis
Hey guys,
Please help me with this one, as I have spent 4 hours without success on it. I want to the chart the following on one chart, with two y-axis. The problem is the x-axis. They are both time periods, but don't overlap exactly. One is an entire calender year. The other is biannual, ending in May and November. Data below. Can someone help please?
| Oct–Apr 2015–16 | $6,111 |
|---|---|
| May–Oct 2016 | $40,491 |
| Nov–Apr 2016–17 | $16,775 |
| May–Oct 2017 | $14,884 |
| Nov–Apr 2017–18 | $28,714 |
| May–Oct 2018 | $26,958 |
| Nov–Apr 2018–19 | $8,925 |
| May–Oct 2019 | $26,784 |
| Nov–Apr 2019–20 | $738 |
| May–Oct 2020 | $4,400 |
| Nov–Apr 2020–21 | $6,900 |
| May–Oct 2021 | $12,400 |
| Nov–Apr 2021–22 | $10,080 |
| May–Oct 2022 | $84,701 |
| Nov–Apr 2022–23 | $1,200 |
| May–Oct 2023 | $0 |
| Nov–Apr 2023–24 | $0 |
| May–Oct 2024 | $0 |
| Year | Total Expenditure |
| 2015 | $3,113,115 |
| 2016 | $4,200,685 |
| 2017 | $5,080,303 |
| 2018 | $6,262,821 |
| 2021 | $11,172,892 |
| 2022 | $16,030,875 |
| 2023 | $20,598,203 |
| 2024 | $1,342,772 |
| 2025 | $1,390,023 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#real-time collaboration
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#dual y-axis
#overlapping x-axis
#chart
#time periods