How to build a chart?

[#1]

Hi,

I need to create a chart that looks like this one below. Pink data is actual sales (June is the last month for which data exist), black data is budget and forecast. First forecast is available for march. What QV object should I use? What is the way to colour cells? The data for sales budget and forecat is available in standard pivit table.

THanks

	I	II	III	IV	V	VI	VII	VIII	IX
Jan-10	388	382	404	409	409	422	444	444	485	508	557	557
Feb-10		400	404	409	409	422	444	444	485	508	557	557
Mar-10			427	435	440	484	488	496	515	533	552	553
Apr-10				435	440	484	488	496	515	533	552	553
May-10					445	484	488	496	515	533	552	553
Jun-10						471	488	496	515	533	552	553
Jul-10							0	0	0	0	0	0
Aug-10								0	0	0	0	0
Sep-10									0	0	0	0
Oct-10										0	0	0
Nov-10											0	0
Dec-10												0

[johnw]

I'm a little lost on what you're actually doing, but I can try to answer anyway. Yes, this looks like a pivot table to me, so I'd use that object. To set the background color in the cells, click on the little + next to the expression. Up will pop a list of things you can adjust. Two of these are "Background Color" and "Text Color". Click on "Background Color" and it will give you a "Definition" box where you can enter a color expression. For instance:

=if(sum(Sales)>500,rgb(200,150,100),lightgray())

You can enter the same sort of color expression for the "Text Color".

[#3]

Thanks John. Colouring cells works fine. Actually now I have a problem with building expression. If you look at my chart there is one dimension (monthyear) on both axes. I also have three metrics - sales (pink) budget and forecast (black). I would like my chart to display data exactly this way i.e. for Apr-10 sales is 435, budget for Jan-10 and Feb-10 was 409, forecast for March was 435. Any suggestions?

Thanks