Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lokesh Sharma
 
Posts: n/a
Default not able to get series value for 3d-surface chart

Hi,

I am able to get series values for all kinds of chart, except for 3D-surface
chart.Here it goes to exception, when I try to acces the values of the
series. Let me know if anyone has solution

Lokesh
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default not able to get series value for 3d-surface chart

You mean you don't get the handy little chart tips that show information
about the point your cursor is over? Surface charts have several
shortcomings, and you've just hit on one of them. They don't do data
labels either.

You could use several other chart types to display the data, maybe not
in the fancy pseudo-XYZ formatting, and still get the chart tips. The 3D
line, 3-D column, and area with 3-D effects chart types provide chart
tips, if you insist on the 3D styling. And of course, the 2D line and
clustered column types show chart tips as well as no parallax or other
distortion of the values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lokesh Sharma wrote:

Hi,

I am able to get series values for all kinds of chart, except for 3D-surface
chart.Here it goes to exception, when I try to acces the values of the
series. Let me know if anyone has solution

Lokesh

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 can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
How to hide a dummy series in a chart legend? holg3r New Users to Excel 2 July 14th 05 09:04 AM
Can I add an average series to a chart with 2 or more series? Yaniv Charts and Charting in Excel 4 June 16th 05 11:37 PM
How to change Series order in a Combination Chart? vrk1 Charts and Charting in Excel 3 April 1st 05 07:21 AM
How to change Series Order in a Combination Chart? vrk1 Excel Discussion (Misc queries) 0 March 31st 05 11:19 PM


All times are GMT +1. The time now is 10:06 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"