Solved

Excel VBA:  looping and altering the XValues and Values properties of each series in the charts

Posted on 2013-01-07
3
347 Views
Last Modified: 2013-01-14
Hi

I am looking for a good Excel VBA example of altering  the data sources of the charts by looping and altering the XValues and Values properties of each series in the charts
0
Comment
Question by:murbro
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
redmondb earned 500 total points
ID: 38750496
Hi, murbro.

If the data is coming from ranges then it may be easier to update each series' Formula. Please see Excel VBA - change x-axis range of an Excel chart for an example from yesterday.

Regards,
Brian.
0
 

Author Closing Comment

by:murbro
ID: 38773571
Thanks very much
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38773581
Thanks, murbro.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilā€¦
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now