Hi All, help please, is it possible to have the date ranges, say months as the rolling series, so that the x axis is fixed as the subject headings and the series roll instead of the x axis, I cant figure it out. Eg, problem a,b,c etc as categories on the x axis and the series as date ranges would show as a stacked bar for each cat a, b etc on the graph. I can create the chart with the date range as dynamic on the x axis, many great examples ( thanks) and then use switch rows columns to give me what I what but it isn't dynamic then just a standard excel chart. How can I do it such that the dates ( months) are the series cheers
Bookmarks