JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,752
- Office Version
- 365
- Platform
- Windows
I'm having a little problem with a stacked area chart. Depending on how wide I make the chart, the X axis, which contains dates, will show just the dates in the table. But if I make it wider, it will add a bunch of intermediate dates and calculate Y axis values for those dates. How can I get it to only show the dates in the table regardless of the width of the chart?
Here's the chart as I want it to look.
Here it is if I make it wider. Since it made these dates at regular intervals, some of the actual dates are not shown.
And here's the minisheet for the table.
Here's the chart as I want it to look.
Here it is if I make it wider. Since it made these dates at regular intervals, some of the actual dates are not shown.
And here's the minisheet for the table.
| $Wordle Data.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | |||
| 4 | Date | 1 | 2 | 3 | 4 | 5 | Sum | ||
| 5 | 11/17/24 | 4% | 9% | 11% | 65% | 11% | 100% | ||
| 6 | 11/24/24 | 5% | 15% | 11% | 60% | 9% | 100% | ||
| 7 | 12/01/24 | 6% | 9% | 11% | 55% | 19% | 100% | ||
| 8 | 12/08/24 | 8% | 15% | 11% | 50% | 16% | 100% | ||
| 9 | 12/22/24 | 12% | 9% | 11% | 45% | 23% | 100% | ||
| 10 | 12/30/24 | 15% | 15% | 11% | 40% | 19% | 100% | ||
MrExcel | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| H5:H10 | H5 | =SUM(Table78[@[1]:[5]]) |
It should have been obvious. Thanks.
