Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSRS 2008 Column Chart with Line

  • 26 January 2010
  • Author: MikeDavis
  • Number of views: 118359
  • 0 Comments

If you want to create a column chart and have a line across the top showing the numbers in two different ways, it is easy to do in SSRS 2008. Just drag over the data into the data field twice. Right click on the data field on change the chart type to line and the other to column.

Here is a table I used to show this.

SSRS 2008 Column Chart with Line

I created a Column chart and dragged over the date and numbers fields as shown.

SSRS 2008 Column Chart with Line

 

 

Notice I placed the Number data in the data field twice. Then I right clicked on the data field and select the change chart type option. Then selected line chart.

 

SSRS 2008 Column Chart with Line

After I select line chart and click OK the chart looks like the image below. It now has columns and lines on the same chart.

SSRS 2008 Column Chart with Line

If you have multiple Series and only want to show for one series in the chart you will need alter the visibility. Here is the chart with a new columns I will use for the series.

SSRS 2008 Column Chart with Line

Refresh the data set and drag over the rep to the series field.

SSRS 2008 Column Chart with Line

Right Click on the data field and go to series properties...

SSRS 2008 Column Chart with Line

 

Then set the visibility expression. Remember to set it to Not equal to, this is setting who to hide, not who to show.

SSRS 2008 Column Chart with Line

 

The Chart will show multiple columns and a single line.

SSRS 2008 Column Chart with Line

Print
Tags:
Rate this article:
1.0
MikeDavis

MikeDavisMikeDavis

Other posts by MikeDavis

Please login or register to post comments.