The attached work book shows two series of data plotted on one axis and partialy overlapping.
I wish to use a secondary axis for the GM% series and still retain the overlap. When I try to do this manually I always fail because the overlap becomes 100%.
I know that I can plot the two series at different bar widths but a partial overlap of the same widths is what I want to achieve.
I want to run a macro while doing this so I can do it with vba.
Can any one help me please?
John
I would use a secondary axis and present the data as a combination of a column and line graph. See file.
Last edited by Vraag en antwoord; 07-04-2021 at 11:21 AM.
Messages have been translated from Dutch to English by means of google translate.
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
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.
Vraag en antwoord,
Thanks for your suggestion. I will use it for now as it is a great improvement, but I am still looking for an overlap of primary and secondary axes.
John
You may add two dummy series. One drawn on primary axis, another on secondary axis.
Play with the sequence of series in graph (see attachement).
If dummy for main axis is before main axis real series, then dummy for secondary axis shall be after real data for the series to be presented on secondary axis.
You may use some reasonable values for these dummy series first (see first worksheet), and when you finish the positioning you shall change all these dummy series to 0 (see second sheet).
After adding series you will have also extra legend entries.
To delete them click on the legend (whole legend will be selected) then click on the unwanted entry - only this entry will be selected.
Then press Delete.
See the screenshot in second worksheet.
Best Regards,
Kaper
Kaper
I have managed to write some code which carries out the essence of your suggestion. I am delighted it works.
Thank you for your interest in my problem, and for your suggestion
John
Glad to hear so,
and thanks for marking thread solved and for a reputation point
If you could share the code here, there is a chance somebody with the same type of problem could find (and reuse) it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks