Different colours in same data series

paulflowe

New Member
Joined
Sep 16, 2002
Messages
2
I have a simple spreadsheet that has a date on the X-axis and a value range on the Y-axis. For each date, a value is assigned (e.g.: for 01/09/02 a value of 100, for 12/09/02 a value of 35.) These values come from cells A2-A32 (for the X-axis) and B2-B32 for the values on the Y-axis.

The default bar chart I'm using has a colour scheme of blue.

What I would like to do is have a certain range of dates in blue, then others in red or alternative colour. For example, I'd like 16/09/02 through 30/09/02 in red, not blue.

Is this possible? Thanks in advance...
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I think you could do this if you plot 2 ranges. Leave your x axis as it is. In column C enter a formula referencing column B for the first range of dates. Make the other cells #N/A. Do the same for column D, but reference the second set of dates, making the other cells #N/A. Then plot columns C and D instead of B.
 

Forum statistics

Threads
1,143,641
Messages
5,719,988
Members
422,257
Latest member
Calion

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top