Scrigroup - Documente si articole

Username / Parola inexistente      

Home Documente Upload Resurse Alte limbi doc  


AccessAdobe photoshopAlgoritmiAutocadBaze de dateCC sharp
CalculatoareCorel drawDot netExcelFox proFrontpageHardware
HtmlInternetJavaLinuxMatlabMs dosPascal
PhpPower pointRetele calculatoareSqlTutorialsWebdesignWindows
WordXml

AspAutocadCDot netExcelFox proHtmlJava
LinuxMathcadPhotoshopPhpSqlVisual studioWindowsXml

Change chart lines and fills

excel

+ Font mai mare | - Font mai mic



DOCUMENTE SIMILARE

Trimite pe Messenger
Plan your database
Copy cell content
Create a chart
Work with standard number formats
Search and sort data
Name and color-code sheets
Create a custom fill series
Change the chart type and layout
The SUM functions
Functions that make choices


change chart lines and fills

To customize any part of the chart, right-click it and choose Properties (the exact name depends on the element). A dialog box opens, and from that dialog box you can change the line and fill colors and properties. Before formatting, make sure you understand the difference between a data series and a data point. Suppose you have a bar chart with three blue bars, three red bars, and three yellow bars. The group of the three yellow bars is a data series. An individual instance of a yellow bar is a data point. Most of the time, when you change the colors or lines, you want to change whole data series at a time. You seldom want to change an individual data point, although Excel does let you do it.




When selecting what you want to change, first click the element. The first click on a data point (for example, a bar) selects its entire data series. A second click on that same data point selects that one data point individually. Be aware of what you have selected before you start formatting. The selection will have black squares around it.

To format a chart element's lines and fills:

  1. Click the element to select it.
  2. Right-click it and choose Properties. A dialog box opens. For example, Figure 5-16 shows the Format Data Series dialog box.
  3. Click the Patterns tab, and from there choose a border and fill color.
  4. Click the other tabs and make selections there as appropriate. The options available change depending on what you're formatting. For example, for a data series in a bar or column chart, you can change from rectangular bars to other shapes such as cylinders and cones on the Shape tab.
  5. When you're finished, click OK.

Figure 5-16: Change the color, fill, and other attributes of the selected chart element.
Figure 5-16: Change the color, fill, and other attributes of the selected chart element.








Politica de confidentialitate



DISTRIBUIE DOCUMENTUL

Comentarii


Vizualizari: 519
Importanta: rank

Comenteaza documentul:

Te rugam sa te autentifici sau sa iti faci cont pentru a putea comenta

Creaza cont nou

Termeni si conditii de utilizare | Contact
© SCRIGROUP 2021 . All rights reserved

Distribuie URL

Adauga cod HTML in site