// example to show how to create/update sparklines on all 
// columns on the current worksheet with alternating blue/red colors
void sparkline_colors()
{
	DWORD dwCntrl = EMBEDGRAPH_IN_LABELS | EMBEDGRAPH_HIDE_AXES | EMBEDGRAPH_HIDE_LEGENDS | EMBEDGRAPH_HIDE_SPECTRUMS | EMBEDGRAPH_HIDE_TEXT_OBJS | EMBEDGRAPH_SPARKLINE;
	Worksheet wks = Project.ActiveLayer();
	if(!wks)
		return;
	
	//add this will require theme_utils.c to be added to workspace
	//int nRowHeight = 20
	//wks_set_col_label_heights(wks, RCLT_SPARKLINE, nRowHeight, false);
	
	waitCursor hrGlass;
	for(int nC = 0; nC < wks.GetNumCols(); nC++)
	{
		if(wks.Columns(nC).GetType() != OKDATAOBJ_DESIGNATION_Y || is_col_all_text(wks, nC) > 0)
			continue;
		
		GraphPage gp;
		DataPlot dp = plot_col(wks, nC, gp, IDM_PLOT_LINE, true, "sparkline_label", true, 0);
		int ncolor = nC%2? SYSCOLOR_BLUE:SYSCOLOR_RED;
		dp.SetColor(ncolor);
		wks.EmbedGraph(RCLT_SPARKLINE, nC, gp, dwCntrl);
	}
}