Dynamic Charts in Excel 365

[crashcoursetrading]

Everyone, I am having a problem making a Dynamic graph in 365.

I have tried the following in reference to the following article:

Dynamic Chart in Excel

What are Dynamic Charts in Excel? A dynamic chart is a special chart in Excel which updates itself when the range of the chart is updated. In static

www.wallstreetmojo.com

This does not work.

-OFFSET('Summary'!$AT$5,0,0,COUNTA('Summary'!$AT$5:$AT$31))

I have tried the same thing with index that doesnt work either.
It saves it as a named range, but when I come to reference its name as a range for a chart, it flags up an error.

There is an error in the formula you entered: Make sure you've included all of the required parentheses and arguments.
Verify any reference to anther sheet or workbook
if you aren't entering a formula, then avoid an equals to ['='] or minus sign ['-']

As you can see, I am not. I am starting to think I cant make dynamic charts in Excel 365.

If anyone knows how to do this, I would really appreciate knowing. I have done this lots in the past. Absolutely frustrated with this.

Column 1 Column 2
1 500(Formula linked to another cell)
2 (if data is in column 2, +1) 1000

The formula then adds in a 3 when there is new data in column 1 row 3.

I tried to use tables, but it appears that you have to enter the data for it to recognise a new row. The graph should then include the new row.

I would appreciate any help on this or prehaps its not possible in 365. Not very satisfactory. If there is an easier way to do this please let me know.


Cheers,

 

[RoryA]

when I come to reference its name as a range for a chart, it flags up an error

How exactly are you doing that? If you are doing it in the select data dialog, you should prefix the name with a sheet name or the workbook name - eg

=SomeSheet!Range_name

 

[crashcoursetrading]

RoryA,

Really appreciate your assistance. Please have a look at the 3 attachments.

Please see snippets of what I have done.

I tried it and it doesn't like the Summary!Cum_Results

 

[RoryA]

Your range includes the header cell in row 5 but that shouldn't really cause the issue - though I'm surprised it isn't showing up as a 0 in the values shown in the Edit Series dialog.

 

[crashcoursetrading]

Tried it without Row 5. Didnt make a blind bit of difference.

Any other ideas??

 

[RoryA]

Can you post the actual file somewhere (eg Dropbox or OneDrive) with dummy data in it? I can’t replicate your error

 

[crashcoursetrading]

Can you post the actual file somewhere (eg Dropbox or OneDrive) with dummy data in it? I can’t replicate your error

Do you use discord? I have it there.

crashcoursetrading@8128

I will investigate If I can share this with you via onedrive.
Here is the link via dropbox. It has some harmless macros in it to shorten some activities for the book.

Error

1drv.ms

 

[RoryA]

It works fine for me using:

=OFFSET(Summary!$AU$6,0,0,COUNT(Summary!$AU$6:$AU$31))

Note: I used COUNT not COUNTA as you have formulas in all the 'blank' cells, which COUNTA would include.

I also removed your INDEX:INDEX names as they were incorrect.

 

[RoryA]

Please note:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Dynamic Charts

I have two columns of data, one that updates when the column next to it has data in it. The second column has a number in it. When there is more data, both columns update automatically. I dont have to type anything in. Can I dynamically chart this data? I tried with tables but it relies on...

chandoo.org

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[crashcoursetrading]

RoryA,

I can not thank you enough for the time you have spent on this. I do appreciate it. Cant believe I got frustrated by something so simple and I could not see the way through ;-(.

It works for me too. I have read the rules on Cross Posting. Appreciate them. Will not cross post in the future unless after a few days.

I have commented in the two other places as well that I have an answer that works.

Thank again.

Alex Chatwin