Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 27th, 2006, 12:22 PM
Registered User
 
Join Date: Jan 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to plot data from an array in a line chart !

This sounds simple, but challenged me. Using Excel VBA I have a 1-dimentional array containing fractions generated by dividing two numbers. I would like to feed the array content into series values of a line chart. HOWEVER, it should not be necessary to store values in a range first. Can this be done without use of ranges at all?
Thank you.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Coloring the chart plot area based on x-axis scale simranjeev Reporting Services 1 October 25th, 2007 02:50 PM
How to draw indicator line in owc line chart AlexOo General .NET 0 July 9th, 2007 10:32 PM
plot bar chart in a web page pratik28 .NET Framework 2.0 1 April 23rd, 2007 03:54 AM
Aligning two chart plot areas - simple but tricky! Alseikhan Excel VBA 0 March 20th, 2006 07:18 PM
Excel VBA: Select range of data and plot chart? xitu Excel VBA 1 December 23rd, 2003 04:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.