Homework Help This preview shows page 1 - 2 out of 2 pages. 1. Excel updates relative references when formulas are copied. Might updating relativereferences when formulas are copied ever produce the wrong result? Could Excel ever betoo smart? Get answer to your question and much more 2. Explain Goal Seek and it's possible uses for a business? Get answer to your question and much more Upload your study docs or become a Course Hero member to access this document
End of preview. Want to read all 2 pages? Upload your study docs or become a Course Hero member to access this document Tags Goal seek, Explain Goal Seek, wrong result, updates relative references Plot your data using lines and bars. Line charts are useful when you want to see how your data changes or fluctuates, either over time, or when measured against a non-time dimension. Line charts can display your data series as either lines, bars, or both. Line charts can plot a single dimension with up to 5 metrics, or 2 dimensions with a single
metric. In this article: Line charts vs. Time seriesLine charts differ from Time series charts in the following ways:
Line chart exampleYou are launching a series of mobile apps and want to visualize the download and 7-day active metrics for the different product versions. Your data might look something like this:
Here's a data source based on this data: The following line charts show 2 ways you could visualize this data. Both charts use Days Since Launch as the primary X-axis dimension. The chart on the left shows the Downloads metric broken down by the Product dimension. The chart on the right shows both the Downloads and 7-Day Active metrics. The chart variation on the right could actually plot up to 5 metrics. Configure the chartSelect the chart, then on the right, use the properties panel to configure the chart options. Setup propertiesThe options in a chart's setup panel determine how the data is organized and displayed. Data sourceA data source provides the connection between the component and the underlying data set.
DimensionDimensions are data categories. Dimension values (the data contained by the dimension) are names, descriptions or other characteristics of a category. At least 1 dimension is required. The first dimension you specify serves as the primary data series in the chart. If you specify a breakdown dimension, the chart is limited to a single metric. Drill downThis option appears on charts that support it. Drilling down gives viewers a way to reveal additional levels of detail within a chart. When you turn on the Drill down option, each dimension you add becomes another level of detail you can drill into. Learn more about chart drill down. Breakdown dimensionThe Breakdown Dimension displays the metric data broken down according to the selected dimension. For example, a chart showing annual sales data could be broken down by a Sales Region dimension to show sales by region, or by an Employee ID dimension to show sales by sales associate. Date range dimensionThis option appears if your data source has a valid date dimension. For Google Ads and Analytics data sources, this option is automatically set to the Date dimension. The Date range dimension is used as the basis for limiting the date range of the chart. For example, this is the dimension used if you set a date range property for the chart, or if a viewer of the report uses a date range control to limit the time frame. MetricMetrics measure the things contained in dimensions and provide the numeric scale and data series for the chart. Metrics are aggregations that come from the underlying data set, or that are the result of implicitly or explicitly applying an aggregation function, such as COUNT(), SUM(), or AVG(). The metric itself has no defined set of values, so you can’t group by it, as you can with a dimension. Learn more about aggregation. At least 1 metric is required. For charts with a single dimension, you can have up to 20 metrics. For charts with 2 dimensions, you can have 1 metric. Set the default sortThe Sort and Secondary sort options in the chart's setup panel control the default sorting behavior. You can select any metric in the chart's data source, or any dimension that is currently displayed in the chart, to use as the primary or secondary sorting field. The Secondary sort option only appears when there is an appropriate combination of dimensions and metrics in the chart. When you specify a metric as a sort field, you can edit the field's aggregation. For example, you could include a numeric field in the chart as a SUM, but sort on that same field's AVERAGE value. Default date rangeThe Default date range property lets you set a timeframe for an individual chart. Default date range options
Learn more about working with dates and time. Google Analytics segmentThis option appears for charts based on a Universal Analytics data source. A segment is a subset of your Analytics data. You can apply segments to your Data Studio charts to help ensure that your Data Studio and Google Analytics reports show the same data. Learn more about Analytics segments in Data Studio. FilterFilters restrict the data that is displayed in the component by including or excluding the values you specify. Learn more about the filter property. Filter options
InteractionsWhen interactions are enabled on a chart, that chart acts like a filter control. You can filter the report by clicking or brushing your mouse across the chart. Learn more about chart interaction filters. Style propertiesA chart's style properties control the overall presentation and appearance of the chart. Color byThis section controls how your data is colored. Learn more about coloring your data. These options appear when you have a secondary (breakdown) dimension in your chart.
SeriesThis section repeats for each metric displayed in the chart. The order of sections matches the order of the metrics listed in the DATA tab.
General
AxesThese options control the display of the chart axes titles and scales. A right Y-axis section appears when you have more than 1 metric in your chart. Axis options
GridThese options control the look of the chart grid.
Background and borderThese options control the appearance of the chart background container.
LegendThese options determine the placement of the chart legend.
Was this helpful? How can we improve it? What tells you that the plot area of a chart is selected?The easiest way to select the chart area is to click just below the top edge of the chart. The Chart Elements menu on the Format tab of the ribbon, and the Format Task pane title will confirm the chart area is selected.
What is a cell reference that refers to cells by their fixed position in a worksheet?Absolute. a cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied and is indicated by the $ sign.
What is a tiny chart in a worksheet cell that provides a visual representation of data such as trends in a series of values group of answer choices?A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.
What is the chart feature that helps identify how information is represented by colors or patterns?Chapter 6. |