Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 26th 08, 09:01 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 53
Default The specified dimension is not valid for the current chart type

Hi,

I have an XLAM (Add-in) which opens a workbook, works upon it and saves it
with SaveAs in the same format as that of the original workbook opened. I get
this error with message "The specified dimension is not valid for the current
chart type" at randomly when the SaveAs operation is called.

Any idea why am I getting this error at SaveAs as I believe the error has
got something to do with Charts/Graphs.

Any information on this would be appreciated.

Thanks in advance.

  #2   Report Post  
Old February 9th 11, 08:26 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2011
Posts: 1
Talking

Quote:
Originally Posted by Anand Nichkaode View Post
Hi,

I have an XLAM (Add-in) which opens a workbook, works upon it and saves it
with SaveAs in the same format as that of the original workbook opened. I get
this error with message "The specified dimension is not valid for the current
chart type" at randomly when the SaveAs operation is called.

Any idea why am I getting this error at SaveAs as I believe the error has
got something to do with Charts/Graphs.

Any information on this would be appreciated.

Thanks in advance.


Dear Anand,

The problem occurs whenever the default chart type is set to other chart types than the ones you are trying to create. For an example, if you try to create line chart and if the default chart in Excel is OHLC (Candlestick Stock Chart) then Excel will be fast to complain "The specified dimension is not valid for the current chart type". The same occurs even if you try to create charts from VB.NET. Hence, first of all change the default chart type to some basic chart types like Line charts. The problem will be solved.

Cheers, Ranjan Poudel
Kathmandu, Nepal


Reply
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
How to draw out a bar chart backed by a 3-dimension database Aaron Charts and Charting in Excel 3 March 30th 07 10:30 AM
Does anyone have a 12-dimension spider chart template in Visio? Robert Charts and Charting in Excel 4 June 12th 06 12:15 PM
How I type SOLD across column length without changing current data MommaRMe Charts and Charting in Excel 1 May 19th 05 09:11 AM
Pivot Chart: cannot apply the default chart type... doco Charts and Charting in Excel 1 January 17th 05 05:55 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 6th 05 12:25 AM


All times are GMT +1. The time now is 01:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017