An explanation of format wave patterns in Excel 2010

Source: Internet
Author: User

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.

You can also choose a color from the color picker for all the points and the wave pattern colors. There are two Drop-down controls next to the library, which allow for color pickup and some other options. In this example, the color of the wave pattern is dimmed and the negative is red:

The format option is stored when the type of wave diagram is switched, so the gray columnar wave pattern is picked up and switched to a line wave pattern, and a gray wave pattern is provided. Also note that the flag option is disabled because a columnar wave pattern is selected, and the flag option applies only to line-type graphs. There are also display axis options in the Axis menu, which apply to all wave type chart types.

By mixing colors, dots, and axes, you can create a wave pattern of various skins.

Note that formatting is group based, and the wave diagram example above is in the same group, so setting a single color/point option will be set to all the wave patterns. If you want a wave pattern to have a different format, you must first remove it from the group.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.