- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Fix It With a Click, Click

Posted By On June 9, 2006 @ 2:45 PM In MS Excel,MS Office Help | No Comments

Fix It With A Click, Click

Use MS Excel charts frequently? Ever find yourself in a situation where you’ve gone completely through the charting process, had a beautiful graph and realized that you spelled a word wrong?

What now?

Do you have to start all over?

Oh, I hope not! There must be a quick and easy solution somewhere.

Breathe easy, there is!

Mistakes in an Excel chart are often fixed with just a click, click.

Did you know that the chart and the data are connected? (A change in the data will automatically change the chart).

Well, this also works with the data labels you highlighted to create the chart. If there’s a misspelled word, you can correct it right in the worksheet and just like magic, the chart is fixed too.

But, what about all the other titles you put into the graph?

Don’t worry, they’re also easy to fix.

Simply click twice on the title to be changed.

That’s right, just click, click.

Well, actually, it’s click, wait a second and click again.

You will get a cursor in the text, so you can make the necessary changes.

When you finish, simply click somewhere else in the graph.

Mistakes are all gone!

P.S. – Did you click twice too fast (in other words, you actually did a double click?) What did you get? Maybe a window with a few tabs and a bunch of options you can change, right? Want to know what all that’s about?

Yes?

Good, then take a look at tomorrow’s tip to find the scoop on customizing your MS Excel charts! : )

~ April

Fix It With A Click, Click

Posted By On November 19, 2004 @ 1:43 PM In MS Excel | No Comments

Fix It With A Click, Click

Last week (back on Tuesday, November 4) we discussed charting—often called graphing—data in MS Excel.

We covered the basics of using the Chart Wizard and by the end we were in a position to quickly create some pretty slick looking stuff from our raw data.

Sounded great!

Everyone’s happy.

Or not…

What if you had gone completely through the charting process, had a beautiful graph and realized that you spelled a word wrong?

What now?

Do you have to start all over?

Oh, I hope not—there must be a quick and easy solution—somewhere…

Breathe easy, there is.

Mistakes in an Excel chart are often fixed with just a click, click.

Do you remember at the end of our discussion where I mentioned that the chart and the data are connected? (A change in the data will automatically change the chart.)

Well… this also works with the data labels you highlighted to create the chart. If there’s a misspelled word you can correct it right in the worksheet and—just like magic—the chart is fixed too.

But, what about all the other titles you put into the graph?

Don’t worry, they’re also easy to fix.

Simply click twice on the title to be changed.

That’s right—just click, click.

Well, actually, it’s click, wait a second, and click again.

You will get a cursor in the text so you can make the necessary changes.

When you finish simply click somewhere else in the graph.

Mistake all gone!


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/fix-it-with-a-click-click/