Agregador de canales de noticias

The Excel Chart SERIES Formula

Jon Peltier -

Data in an Excel chart is governed by the SERIES formula. This formula is only valid in a chart, not in any worksheet cell, but it can be edited just like any other Excel formula. The SERIES Formula...

continue reading...

Saving Changes in the Personal Workbook

Allen Wyatt's Excel tips -

The Personal workbook is a special place used to store information and macros that you can access from all the other workbooks on which you work. If you are confused as to why Excel continually asks whether you want to save this special workbook, here are some ideas on why it may be happening.

Read this ExcelTip: Saving Changes in the Personal Workbook
Microsoft Excel Tips - Learn Excel Faster!

Aligning Positive and Negative Whole Numbers in a Column

Allen Wyatt's Word tips -

When you use a table to present numeric information, you may want to have Word align the numbers in the table. This can be a challenge in some situations, such as if your negative numbers use parentheses around them. Here's how to align such numbers properly within the table.

Read this WordTip: Aligning Positive and Negative Whole Numbers in a Column
Microsoft Word Tips - Learn Word Faster!

Stagger Axis Labels to Prevent Overlapping

Jon Peltier -

When you have a chart that is too narrow, and has too many axis labels, or the labels it has are too long, Excel tries very hard to prevent the labels from overlapping. Usually Excel will incline the...

continue reading...

Switch X and Y Values in a Scatter Chart

Jon Peltier -

This tutorial shows VBA procedures that help manipulate the chart SERIES formula to switch X and Y values (axes) in an Excel XY scatter chart. The post Switch X and Y Values in a Scatter Chart...

continue reading...

Páginas

Subscribe to necesitomas.com agregador