Step1: Create a table for the report as shown below: Create Table SSRSReport( Id Int Identity(1,1), Period Varchar(10), MyBrand Int, CompBrand Int, Maximum Int, Minimum Int)

Insert the data in the table

Step2: Create data source and dateset so as to fetch the data from above table. Create a SSRS report with chart type as Area and drag and drop Maximum and Minimum columns from the dataset onto the chart data area.

Step3: Drag Period as the category field

Step4: Select Series Properties of "Minimum" and set its Fill property to White Color. Similarly set Silver for Maximum Series.

Step5: Drag MyBrand to the data region of the chart and change its "Type" property (from the property window) to Line,Plain. Similalry drag Comp Brand and make the changes as done for MyBrand.

Step6: Select series MyBrand and set its "Marker" property to "Diamond". Also set the line color as "Blue". Similalrly set the marker as Square and line color as Red for CompBrand.

Create a simple linear chart with your measures in series and Period in categories.

-Keep Linear chart type for MyBrand and CompBrand series.

-Change to Range chart type for maximum serie

-Remove minimum serie

-Configure your maximum serie with

  -rename it to *rangeprices*
  -add **Minimum** field as **Low Value**
  -move back serie in order to go behind linear ones