An explanation of format wave patterns in Excel 2010

Source: Internet
Author: User

The wave chart of this paper shows the net profit of three book suppliers in 2008 year by month. Individual net profit values tell which vendors are doing well, and wave charts help identify trends that follow numbers: Seattle and Houston have fallen in summer sales, usually their profits have been climbing, and Richmond has been underperforming in addition to the last one months.

Look at the formatting options for the three wave graphs. When you select a wave chart, a Wave Diagram contextual tab appears in the Ribbon, similar to selecting a chart or PivotTable report. The following are formatting options, shows/hides, and styles in the tab of the Wave Diagram tool context:

A wave chart has a library that resembles a chart and a table, where you can quickly choose a color scheme. Some of the unique options for the wave pattern are in the show/Hide group, where you can activate the point. Selecting a point option turns on or highlights that point in each wave pattern, so if you turn on the high, you'll get a high in each wave pattern for a line-shaped chart. For histogram and profit and loss graphs, points representing highs will be formatted differently than others. If it is related to the high point, it will be highlighted. The negative point will open or highlight the negative points in the wave pattern, and if the negative points in the example wave pattern are opened, the results of the following graphs are obtained:

At this point, these wave patterns become quite obvious, emphasizing that Richmond has only one profitable month of the year. The library will also be updated to reflect the options selected in the Show/Hide group.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.