Charting Using Defined Names

P

Posse John

I have a workbook that contains numerous charts. I am updating the chart
trends by manually editing the formula that define the trend data.

I would like to create defined names, and through VBA, update the definition
for the ranges.

HOW do I incorporate a defined name into the formula for the trend?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Chart with OFFSET defined name not working 2
Dynamic Chart with Defined names 4
Copying Named Ranges in Chart Series 1
Define chart range using indirect reference 4
defined names and setsourcedata 2
Charts based on 'virtual' names 2
Change background for ALL charts without custom defining all chart 4
Colours in user-defined charts 9

Top