Entering/editing chart titles in Excel 2007 using DNS
You'd expect this to work by selecting the chart title (or, e.g., axis label) and then dictating a replacement. Unfortunately, due to DNS bugs, this doesn't work.
More precisely, something very weird happens. DNS dictates into the last cell selected rather than the chart title! If you press F2 while DNS is active, essentially the same thing occurs. Likewise if you select part of the title and then dictate.
After a fair amount of investigation by me with help from Chuck, Graham (IT Speaking), and Bruce, I present two workarounds for this problem.
(1) if you just want to replace the chart title (not edit the existing title), having a macro send {space}{backspace} while the chart title is selected (single solid line around it) it will put the cursor in the formula bar; dictate your new title then a new line. See Vocola replace command example at the end. Note that the formula bar is not Select-and-Say supported.
(2) if you want to edit the chart title, it is possible to copy the chart title text, then invoke the dictation box on the resulting text. When the dictation box transfer button is "clicked", the new text replaces the existing chart title text. Afterwards, the chart title test is left selected. See edit command below.
- Mark
Note that a chart or chart part must already be selected for the below commands to work.
Ribbon(keys) := {f10}$keys;
# ribbons present only when a chart is selected:
Design() := Ribbon(jc);
Layout() := Ribbon(ja);
Format() := Ribbon(jo);
<place> := (
chart title = t m
| X. axis title = i h m
| Y. axis title = i v m
);
# no editing, just dictating a new version; dictate a newline at end
replace <place> = Layout() $1 {enter} Wait(100) {space}{backspace};
edit <place> = Layout() $1 {enter} Wait(100)
{shift+f10}{down_2}{enter} {ctrl+a}{ctrl+c}
HeardWord(show, dictation, box);
Mark, It would be a courtesy
Mark,
It would be a courtesy when you interrupt an existing thread to embed links to the thread(s) you are abandoning. Responding in place seems best for the sake of continuity of the community.
Bruce
So noted. The original
So noted. The original thread was http://www.speechcomputing.com/node/2635.
I was concerned that people would not see the final solution buried in the comments and with a misleading title.
I will add a forward reference from that thread as well.