Chart by Year side by side years in one chart
Hi is it possible to create a report with a chart in it with two years side by side for comparison by month?
e.g.
april 2007 april 2008 may 2007 may 2008 june 2007 june 2008 in a bar chart?
I couldnt figure it out and I figured i would ask.
e.g.
april 2007 april 2008 may 2007 may 2008 june 2007 june 2008 in a bar chart?
I couldnt figure it out and I figured i would ask.
ASKER
Im looking at it.. it has 17 pages on the one im looking but I dont see one that does what you are reffering to.. can you be a little more specific? which chart?
There is a BAR chart. It is on page 5. It isn't doing exactly what you are but the idea might be similar.
mlmcc
mlmcc
I'm no chart expert, but I think all you need is to group the data by month in that order. One way to do that would be to create a formula that combines the month and year, in that order, and group on that. For example:
// mm-yyyy
(Month ({table.datefield}) * 10000) + Year ({table.datefield})
That would give you values like 042007, 042008, 052007, 052008, etc. Grouping the data for your chart on that formula should give you the order you want. I think. Like I said, I'm no expert on charts, but it seems like it should work.
James
// mm-yyyy
(Month ({table.datefield}) * 10000) + Year ({table.datefield})
That would give you values like 042007, 042008, 052007, 052008, etc. Grouping the data for your chart on that formula should give you the order you want. I think. Like I said, I'm no expert on charts, but it seems like it should work.
James
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
James, you the man! this completely worked!! I thought this was impossible.. thanks!
now that youve given me exactly what I wanted I need to figure out how to format it... its hard to read in the sense that they want spaces or padding between the two months etc.
Again thanks A+
now that youve given me exactly what I wanted I need to figure out how to format it... its hard to read in the sense that they want spaces or padding between the two months etc.
Again thanks A+
You're welcome. I'm glad I could help.
As for the spacing, that could be a problem. My impression is that you don't have much (any, really) choice there, but I could be wrong. If you get stuck, you could always post another question about that (assuming that you haven't already). I'm sure that there are people around here that know a lot more about CR charts than I do.
James
As for the spacing, that could be a problem. My impression is that you don't have much (any, really) choice there, but I could be wrong. If you get stuck, you could always post another question about that (assuming that you haven't already). I'm sure that there are people around here that know a lot more about CR charts than I do.
James
mlmcc