color chart
 

Hi all

this is line chart with sale in money on vertical

and quarters 01/08, 02/08,03/08,04/08 and
01/09.forecast,02/09.forecast on horizontal

How can I color the chart wherre forecast is different that quarter in the
past?

Do I need macro or just using formula.

Thanks in advance
Daniel Ku

color chart
 

So are you trying to compare forecast to forecast or forcast to actuals? Do
you want to do it for all quarters, or just the current quarter? If you data
is by month why are you comparing by quarter? If Jan 08 to Mar 08 were 1, 2,
1 and Apr 08 to Jun 08 was 2, 1, 1 would you consider this the same - the
months are different but the quarter totals are the same?

why not show us some sample data and tell us what the numbers would look
like on the chart.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Daniel" wrote:

Hi all

this is line chart with sale in money on vertical

and quarters 01/08, 02/08,03/08,04/08 and
01/09.forecast,02/09.forecast on horizontal

How can I color the chart wherre forecast is different that quarter in the
past?

Do I need macro or just using formula.

Thanks in advance
Daniel Ku

color chart
 

example is below

quarter: q108 q208 q308 q408 q109forecast q209forecast
sale : 20M 30M 30M 50M 30M 40M


when making a line chart for all sale, but problem is all have the same
color

If I want to graph line chart but need to emphasize the sale in forecast by
different color. How to do that?

Thanks
Daniel

"Shane Devenshire" wrote:

So are you trying to compare forecast to forecast or forcast to actuals? Do
you want to do it for all quarters, or just the current quarter? If you data
is by month why are you comparing by quarter? If Jan 08 to Mar 08 were 1, 2,
1 and Apr 08 to Jun 08 was 2, 1, 1 would you consider this the same - the
months are different but the quarter totals are the same?

why not show us some sample data and tell us what the numbers would look
like on the chart.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Daniel" wrote:

Hi all

this is line chart with sale in money on vertical

and quarters 01/08, 02/08,03/08,04/08 and
01/09.forecast,02/09.forecast on horizontal

How can I color the chart wherre forecast is different that quarter in the
past?

Do I need macro or just using formula.

Thanks in advance
Daniel Ku

color chart
 

First select a single point on the line. Double-click on that point to bring
up the Format Data Point dialog box. You can then change the color of the
point via the dialog box.

--
John Mansfield
http://www.cellmatrix.net


"Daniel" wrote:


example is below

quarter: q108 q208 q308 q408 q109forecast q209forecast
sale : 20M 30M 30M 50M 30M 40M


when making a line chart for all sale, but problem is all have the same
color

If I want to graph line chart but need to emphasize the sale in forecast by
different color. How to do that?

Thanks
Daniel

"Shane Devenshire" wrote:

So are you trying to compare forecast to forecast or forcast to actuals? Do
you want to do it for all quarters, or just the current quarter? If you data
is by month why are you comparing by quarter? If Jan 08 to Mar 08 were 1, 2,
1 and Apr 08 to Jun 08 was 2, 1, 1 would you consider this the same - the
months are different but the quarter totals are the same?

why not show us some sample data and tell us what the numbers would look
like on the chart.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Daniel" wrote:

Hi all

this is line chart with sale in money on vertical

and quarters 01/08, 02/08,03/08,04/08 and
01/09.forecast,02/09.forecast on horizontal

How can I color the chart wherre forecast is different that quarter in the
past?

Do I need macro or just using formula.

Thanks in advance
Daniel Ku