CHANGE BACKGROUND COLOR EVIEWS 9 SERIES

To make the second series useful, assign it to the secondary axis.Д¬hange the secondary Y axis scale so it has min and max of 0 and 1. The added series is aligned with the bottom of the chart. In many cases, this is done manually, but I can use a formula based on the date in column A to calculate 0 or 1: =1*(MOD(A2,7)<=1)Д¬opy the column of data, select the chart, and use Paste Special to add the data as a new series. Next to the already plotted data, enter a 1 where you want the background to be shaded, and zero otherwise. There is an obvious cyclical pattern, with weekends having about 40% as much traffic as weekdays.Д¬reation of the column chart series that highlights weekends begins with a column of data added to the worksheet. The following line chart is a time series of pageviews for the PTS Blog between mid-March and May. This is accommplished using a combination of a line series to show traffic with a column series to highlight weekends. In this example, I will use a simpler example, plotting the readership of this blog over the past couple months, and highlight weekends. You may want to show financial performance over time, for example, and point out the periods when the economy was in a recession. Sometimes it helps a time series chart if you can highlight certain periods with a different color background.

Change background color eviews 9