+ Reply to Thread
Results 1 to 1 of 1

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

  1. 02-29-2016, 02:44 AM #1
    vinodh18
    vinodh18 is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel charts. Is it possible to copy and pasta a data series quickly between charts?
    By davidx in forum Excel General
    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. I want to create multiple charts using a series of non-numerical data in Excel 2010.
    By chuerta2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-18-2013, 10:13 AM
  4. How to show actual formulas in cells and can I use find/replace to change a series of valu
    By tiggi in forum Excel Formulas & Functions
    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. How to keep the LineType of One Series Collection While Other Collection Types Change
    By Mordred in forum Excel Charting & Pivots
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1