Hi there,
I'm having trouble getting rid of the gaps in the bar graph ('volume' data). Please help!
Thank you in advance!
-Wikster7
Hi there,
I'm having trouble getting rid of the gaps in the bar graph ('volume' data). Please help!
Thank you in advance!
-Wikster7
You are using Date axis for your X axis. This is what is causing gaps as you have missing dates.
Change it to Text, since it's not contiguous series and you want it to be treated as Categorical rather than Continuous axis.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Hi CK76,
Thank you for the help. I changed the dates to text and it got rid of the gaps, but it flipped the entire graph and I don't know how to flip it back. Please see the images below: original chart (first) and what I have now (second).
Original.PNG
Flipped.PNG
Thank you!
-Wikster7
Go to Chart Elements menu -> Axis.
Set both the primary and secondary Horizontal to reverse order (and as text type), and then remove the one you don't need.
I don't think I did it right. Images below.
format axis.PNG
reverse order.PNG
You'd need to set both to reverse order for horizontal. I think you only have primary horizontal in reverse.
Now this may inverse the format for Volume Series. If that is undesired. You'd just need to sort the source data.
Below is sample with source data sorted oldest to newest on date column.
0.JPG
I'm not sure how to do what you outlined, but I just reversed the raw data and it did the trick.
Thank you for your help CK76!
-Wikster7
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I actually have one last question!
How do I format the x-axis so that only one date per quarter is shown?
Thanks!
Thank you for all the help CK76 - it's much appreciated!
-Wikster7
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks