LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Discontinuous range of X Values

Anyone know how to set the X Values of a series collection item for a
HLC stock plot to a discontinuous range?

I can define a range using the Union function and set the X Values to
that range without an error. But the chart is created with nothing
defined for X Values.

I've also tried to generate a string of addresses. That works, but
the displayed values are the addresses, not the values in the cells.

Thanks,
John

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average range of discontinuous cells Nadine Excel Worksheet Functions 1 May 11th 10 07:14 PM
Charting a discontinuous series Branchola Charts and Charting in Excel 1 March 6th 08 02:33 PM
sum value of nonblank discontinuous cells stumped New Users to Excel 3 February 29th 08 03:27 PM
Discontinuous Range via VBA using R1C1? (PeteCresswell) Excel Programming 7 December 2nd 06 01:12 AM
Discontinuous X axis genscientist Charts and Charting in Excel 3 December 6th 05 01:46 PM


All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"