Infinite opportunities?  Endless problems?  Limited resources?  Talk to us!
Operations
Consulting
Software
Consulting
Publishing and
Training
Applied
Solutions
Excel add-ins
and tutorials
Charts Excel and VBA
Case Studies
VBA
tutorials
PowerPoint
Add-Ins
Miscellenia
You are on the Home/Excel/Add-Ins/Interactive Chart page
About this site

What's new

Google
Web
This Site
 

 

This Excel add-in shows the Y or X value associated with the corresponding X or Y value for any XY Scatter chart.

The compressed (zipped) files

Function

Installation and Use

Version 1.1m now works with XL97!

Function

As Figure 1 shows, specifying the X (or Y) value in the dialog box shows the corresponding Y (or X) value both in the dialog box and on the chart itself.  The values are shown both in their raw (user entered or computed) form and in the format of the appropriate chart axis.

If the chart has multiple XY Scatter charts, select the series of interest with the drop down box on the right side of the dialog box.

If used with a combination chart, especially with secondary (Y or X or both) axis, the graphical display may be confusing and/or unreliable.

The add-in uses piecewise linear interpolation to calculate the value of interest.  If it encounters an error, the error description is shown instead of the numerical result.

The add-in adds two series to show the graphical results as shown in the blue and brown dotted lines in Figure 1.  Closing the dialog box deletes both the extra series.

There is no additional help available for this add-in.


Figure 1

Installation and Use

To install it, and for installation troubleshooting see this guide.  Once installed, when a chart is selected, you will see a TM menu.  Select it to see, and select, the Interactive Chart Display... menu item (see Figure 2).


Figure 2

 

 

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.
By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Ads from amazon.com

[Optional] Survey (current rating of site: 3.7 out of 4)  If you will take a moment to provide your comments, it will help improve the site both for you, and for other visitors.

On a scale of 4 (just what I need)
to zero (totally useless)

How do you rate the information

on this page?

  on this site?

[Optional]

Your name
Your email address
Other comments
 
Monitor page
for changes
    
   it's private  

by ChangeDetection
A comment selected at random:

 

 

Copyright © 2000-2008 Tushar Mehta.
Send comments and suggestions about the web site to webmaster@tushar-hyphen-mehta-dot-cee-oh-em
Last edited April 14, 2008