+ Reply to Thread
Results 1 to 1 of 1

Charts in a excel sheet gets hidden when data is added from series collection.

  1. #1
    Registered User
    Join Date
    02-29-2016
    Location
    chennai
    MS-Off Ver
    2010
    Posts
    1

    Charts in a excel sheet gets hidden when data is added from series collection.

    Charts in a excel sheet gets hidden when data is added from series collection and has values from different cells in excel.

    Sample Code :

    .Chart.SeriesCollection.NewSeries
    .Chart.SeriesCollection(1).Values = "='Comparison Report - Version'!E10,'Comparison Report - Version'!H10,'Comparison Report - Version'!K10,'Comparison Report - Version'!N10"

    After generating the chart with the above code, when i save my worksheet the chart gets hidden.

    Any one can help me.

    Thanks in Advance.

    ~Vinodh.
    Last edited by vinodh18; 02-29-2016 at 02:46 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 09-15-2015, 04:12 AM
  2. [SOLVED] Adding 1 series of data in 234 charts were 3 series already exist
    By Joachimjr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2014, 01:56 AM
  3. Replies: 0
    Last Post: 09-18-2013, 10:13 AM
  4. Replies: 1
    Last Post: 03-26-2013, 01:55 PM
  5. New series added to charts are invisible!!
    By radarguy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-28-2012, 04:23 AM
  6. Replies: 2
    Last Post: 12-23-2011, 11:04 AM
  7. Data Series in Chart are added together?
    By jonnyt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-23-2009, 01:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1