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: 1
Default de-link *dates* in chart from data

I have excel vba code that creates a chart from a table of data, then
de-links the chart from the data and removes the data, as described
he http://peltiertech.com/Excel/ChartsH...ChartData.html
(scroll down to the VBA bit).


The problem with this is that the x-labels on my chart are dates, and
when I de-link them the x-labels become apparently meaningless numbers.
I have almost torn my hair out trying to fix this, but I have not found
a solution.


I know this has been discussed before, he
http://groups.google.com/group/micro...40c5d45d534e92
and he
http://groups.google.com/group/micro...53113c57ea33aa

but no solution appears to have been mentioned in the past. I figured I
would check again to see if any ideas were out there.

 
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
Chart Title Link to Data Table GasGal Charts and Charting in Excel 1 March 6th 09 12:09 AM
How do I link data to a chart from multiple worksheets? Donna Charts and Charting in Excel 1 October 10th 08 05:35 PM
How do I keep chart/data link when copying worksheet Andy at Trinity Charts and Charting in Excel 7 July 10th 07 08:24 PM
How do you link chart source data when you copy the chart? mamagirl Charts and Charting in Excel 1 December 8th 06 02:40 AM
How do I create a link between columns from a data chart? Sara Excel Discussion (Misc queries) 1 June 2nd 06 06:51 PM


All times are GMT +1. The time now is 07:29 PM.

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

About Us

"It's about Microsoft Excel"