Search results for query: *

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.

I have an excel sheet that list various crypto coins that I and my team owns. We use it to track the values and determine when to buy and sell. On a separate spreadsheet, I keep a log of average cost on a time line. I then use that data to create charts of each. I would like to be able to hover...

is it possible to "pop-up" an Excel chart by clicking on a cell with the chart name?

This should be simple, but I am puzzled. I have a spreadsheet that keeps track of supply costs per month. When a new max is reached, I have a call that indicates, "new max". I won't to automatically replace the number in the corresponding cell to show the new Max Value; I tried the formula...

The file is an xlsm file. One of the error popup stated, "You can't use [cntr M] to start a macro." That's what I have neen using for many years.

MS just updated my Office files again without asking of course. I have been using spreadsheets that I created several years ago and mow they do not work. Especially the macros and I can't save any changes because Office says the files are blocked! I went to trust center in Excel and apprved...