chart formatting

Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...

Cant really think of the right way to word this questions so I apologize in advance. I have a chart that I basically want to be the cover page to an excel worksheet. On the chart I have VBA functions that when clicked take you to that particular area represented on the chart. What I cannot...

Let me preface this with I am a very new VBA user--with that said, can someone help me figure out how to change my secondary axis formatting? My boss has very particular likes and I am trying to slowly set up a macro that can run and update all formatting to meet his preferences. In this...

Hi all, I am developing a dashboard to convey a heap of information in the most visually appealing way possible and am having trouble with some VBA code. I am trying to write some code which will shift the formatting between a print view (which is mostly black and white) and a normal view...

So I know in Excel VBA you can modify the active chart's layout easily enough using the applylayout (X) function, but my questions is this: Can you identify what the activechart's layout currently is? for example: I have a activeX control button on a page that I want to use to cycle through...

I have a spreadsheet that has multiple charts on multiple tabs. The data that is used for these charts is stored to the left of the chart in tables and when I add or remove rows to these tables the physical size of the chart changes. What I want is a macro that I can use on ANY chart that I...