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.

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

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