•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
Our take
Creating a chart with dual y-axes and overlapping x-axes can be a complex task, especially when the time periods do not align perfectly. In this case, you have data spanning an entire calendar year alongside biannual periods ending in May and November. This challenge can be addressed by carefully structuring your chart to represent both datasets effectively. If you’re feeling stuck, let’s explore possible solutions to visualize your data clearly and meaningfully, ensuring that both timeframes are represented accurately.
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]
Read on the original site
Open the publisher's page for the full experience
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