Dual currency axis labels- Excel 2007 Chart

[ncaro2777]

I have two somewhat related questions regarding Excel 2007 charts.

1. I would like to list both USD and another currency on the same axis to label data in a chart. This way US users can see the data plots in USD while UK users can see pounds.

2. I have graphed data and I would like to add an additional data point to the graph to further identify the information but I don't want to use a secondary axis. Specifically, I'm graphing total sales by market but I would like to show the gross margin for each as a simple label without actually graphing it.

 

[SkipVought]

hi,

I'd probably use an Option Box control to "switch" the currency units.

There are add-on applications that allow for this osrt of thing, or you could program it yourself using VBA. One such place is

http://www.j-walk.com.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]