I am trying (in vain) to use two colours for one data series in an Area chart. See the attached zipped files
There is a potential solution in 'sheet2' but it gets messy updating for a new month.
Any suggestions....?
I am trying (in vain) to use two colours for one data series in an Area chart. See the attached zipped files
There is a potential solution in 'sheet2' but it gets messy updating for a new month.
Any suggestions....?
Last edited by germullen; 05-04-2006 at 04:07 AM.
Well, I'm not sure how to make one data series have two different colors.
Your solution on sheet2 looks pretty good. I was thinking also, instead of
having a second row for your "second" series, use columns for May-forward on
the same row as your second series data source.
As the months go on, you would then simply need to change your data source
properties for each series. Using a named range as your series data source
may even make this more automatic.
If there is any way to make a single range have two colors, I'm sure either
Debra Dalgleish www.contextures.com or Jon Peltier www.peltiertech.com would
have it on their sites. Though I looked briefly and didn't see anything
directly relating.
Hope that helps a bit.
"germullen" wrote:
>
> I am trying (in vain) to use two colours for one data series in an Area
> chart. See the attached zipped files
>
> There is a potential solution in 'sheet2' but it gets messy updating
> for a new month.
>
> Any suggestions....?
>
>
> +-------------------------------------------------------------------+
> |Filename: Profit.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4722 |
> +-------------------------------------------------------------------+
>
> --
> germullen
> ------------------------------------------------------------------------
> germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
> View this thread: http://www.excelforum.com/showthread...hreadid=538451
>
>
Dominic, it does work using two series on the same row, that's very neat, deceptively simple in the end. I didn't use Columns, I used Area for both.
Series 1 is January up to current month (using a named range which I can extend easily each month)
Series 2 is for the full year (ie January up to current month plus forecasts to year end). Series 2 is the highest in 'series order' so that it doesn't block out series 1 for earlier months.
I wasn't expecting to find a solution to this one, thanks for your help.
Ger
Last edited by germullen; 05-04-2006 at 04:09 AM.
You're welcome Ger.
I'm glad you got it working.
"germullen" wrote:
>
> Dominic, it does work using two series on the same row, that's very
> neat, deceptively simple in the end. I didn't use Columns, I used Area
> for both.
>
> Series 1 is January up to current month (using a named range which I
> can extend easily each month)
>
> Series 2 is for the full year (ie January up to current month plus
> forecasts to year end). Series 2 is the highest in 'series order' so
> that it doesn't block out series 1 for earlier months.
>
> I wasn't expecting to find a solution to this one, thanks for your
> help.
>
> Ger
>
>
> --
> germullen
> ------------------------------------------------------------------------
> germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
> View this thread: http://www.excelforum.com/showthread...hreadid=538451
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks