Last seen: Oct 31, 2025
Turns out that doesn't work either. Per our AI friends the only way around it is to create some VBA code to populate the chart data
I've been playing around with various solutions and I think I have one that works and would like your thoughts on the attached file. The answer appear...
@riny Thank you for your help
I'm in an Excel chart and I want to replace 2025 with the value in a cell and not have it static
I am using Office365 and I think the confusion is that this needs to be how I select data within a chart. Your formula works fine in a cell but not as...
Unfortunately, it doesn't, it generates an error, "That function isn't valid"
Thank you Charles, now I have to spend a lot of time learning how this code works. This is VERY helpful
Charles, I was able to download the file, took me about 4 times as I kept getting empty files. This is going to take me a bit of time to read ...
Unfortunately, I can't download the file. All I get is garbage on my screen. Thanks any way.
Phil, Thanks for your response, this more of the response I was looking for, rather than a "yes". The form that I showed was for a contact data...
Not a particularly informative answer. I want it to look like that and I want it to act like that. My question was more about is there a forms b...
Turns out the answer to my problem is very simple and should have been obvious but then obvious isn't always obvious. Here is the solution =TEXTSPL...