'

Three In-Cell Alternatives for Using Charts in Excel

Понравилась презентация – покажи это...





Слайд 0

3 OFFICE 2016. EXPLAINED. In-Cell Alternatives for Using Charts in Excel GET STARTED


Слайд 1

TIP 1 Use Sparklines to create graphic in-cell charts Sparklines are great to give you (or your audience) the big picture quickly without the fuss of a full-fledged chart. There are three types of in-cell Sparkline charts you can create. To add one of these three Sparklines, go to the Insert tab and click the button for the Sparkline you want to use. NEXT SLIDE


Слайд 2

TIP 1 Line JAN FEB MAR APR MAY JUN 61 (654) 330 646 831 574 Oregon 638 236 (345) 835 278 877 California 643 (355) 129 154 709 324 Washington TREND NEXT SLIDE


Слайд 3

TIP 1 Column JAN FEB MAR APR MAY JUN 61 (654) 330 646 831 574 Oregon 638 236 (345) 835 278 877 California 643 (355) 129 154 709 324 Washington TREND NEXT SLIDE


Слайд 4

TIP 1 Win/Loss JAN FEB MAR APR MAY JUN 61 (654) 330 646 831 574 Oregon 638 236 (345) 835 278 877 California 643 (355) 129 154 709 324 Washington TREND NEXT SLIDE


Слайд 5

1. USING SPARKLINES TO CREATE GRAPHIC IN-CELL CHARTS Formatting Options to Consider Consider the following formatting options for your Sparkline Charts • Adjust the width or height of the cells containing the Sparklines to tell your story better by giving more context to the scale being displayed • Add markers to all of the data points, or just the high and low points • Use an axis to display negative numbers • Change the colors to match your document’s theme JAN FEB MAR APR MAY JUN 61 (654) 330 646 831 574 Oregon 638 236 (345) 835 278 877 California 643 (355) 129 154 709 324 Washington TREND


Слайд 6

TIP 2 Use Conditional Formatting Options to create in-cell charts Conditional formatting is another quick in-cell alternative to creating a separate chart in Excel. Simply select your data and then choose Conditional Formatting on the Home tab. Start by going to the Home tab, then click on Conditional Formatting > Data Bars > Solid Fill NEXT SLIDE


Слайд 7

TIP 2 Conditional Formatting By default, Excel will continue to show the data values in those cells over the top of the bars. NEXT SLIDE


Слайд 8

Quick tip! If you just want to see the bars, go back to the Conditional Formatting menu and choose Manage Rules. Then click Edit Rules and check the box “Show Bar Only.” NEXT SLIDE


Слайд 9

TIP 3 Use Symbols and the REPT function for in-cell charts The third in-cell alternative is to use the REPT or Repeat function as an alternative to charts in Excel. NEXT SLIDE


Слайд 10

TIP 3 REPT function The REPT function will repeat the same text or symbol a specific number of times. Let’s say you have salary information in Column D of your workbook. In Column E you could type: =REPT(“$”,D2) For each value in Column D, this will give you a corresponding number of dollar signs in Column E. NEXT SLIDE


Слайд 11

Quick tip #1 If the number is too large, you can divide the value to make it smaller. For example, you could have =REPT(“$”,D2/10000) which will give you fewer dollar signs but it will still give you a relative number for your data set. Quick tip! Quick tip #2 Instead of using text as the first argument in the REPT function, you can insert a symbol from the Symbol menu on the Insert tab. NEXT SLIDE


Слайд 12

FOR MORE TIPS ON GETTING THE MOST OUT OF EXCEL, VISIT LYNDA.COM/EXCELTIPS


Слайд 13


×

HTML:





Ссылка: