Recent content by billheath

This is the code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'simple example of ' dynamically positioning chart and ' assigning values to a single series chart 'you must have a defined range of series names ' and a defined range for the columns containing the Values...

This has quit workin. The graph comes up but has laost the neccessary data. Thanks

SKIP, You said something about updating the VBA for me. Have you done that? You're probably like me - I didn't work over the holidays! Thanks again for all your help. Really wish I had your knowledge and experience. Bill

Skip, Thanks so much for your help! Bill

My goal is to have 2 excel tables. One for Stock quotes and one for crypto. I sent you the Crypto one. We want to graph the values by date. When we select a stock or crypto symbol, We want to pop up a chart showing the prices by date. It would be ideal to show dates instead of points (1 2 3 4...

If I can. I need to keep an ongoing record for me boss. Thanks

https://res.cloudinary.com/engineering-com/raw/upload/v1640207891/tips/Crypto_values_to_send_wlqpoj.xlsm

How do I send it to you?

The additional rows are working. The data points are in the columns based on date

This works great until I have 73 rows. None of the rest show on the chart. Pardon my ignorance, but how do I change the series data?

Also, I defined the ranges within the excel sheet: Name:Names!SeriesNames Refers to:Names!$B$3:$B$6 Name:Names!SeriesYValues Refers to:Names!$C3:$H3

The code stops on the 2nd line starting with: "If Not Intersect(Target, Union(Me.Range("SeriesNames"), Me.Range("SeriesYValues"))) Is Nothing Then" I changed Active Cell to Target

Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(ActiveCell, Union(Me.Range("SeriesNames"), Me.Range("SeriesYValues"))) Is Nothing Then With Me.ChartObjects(1).Chart.SeriesCollection(1) .Name = "=" & Intersect(ActiveCell.EntireRow...

Thanks, I'm going to give up for today and will try again tomorrow.

I have done a bit of VBA. I'm not proficient in it. I have ordered the book that you recommended. We'll see how that goes.