I am creating a chart that maps Monthly averages with Daily averages based on the current date. So that the x-axis on the chart should contain the values 'Nov, Dec, Jan, ... Sep, Oct' for the monthly averages AND also '1, 2, 3, 4,...,30, 31' for the daily averages. All of these values will appear on one chart's x-axis.
My first assuption was to put the values that I want to appear on the chart into a field on my Oracle table and use this field on the "on change of" section for the Data field on the Chart expert.
I don't think I can use the Order button on the chart expert because the months will appear in a different order based upon the current month.
I also considered concatinating a numeric value in front of the value that I want to appear on the x-axis (thus controlling the order), but then this value would show up on the chart as well (which I don't want).
How can I control the order that the values appear on the x-axis of my chart??
My first assuption was to put the values that I want to appear on the chart into a field on my Oracle table and use this field on the "on change of" section for the Data field on the Chart expert.
I don't think I can use the Order button on the chart expert because the months will appear in a different order based upon the current month.
I also considered concatinating a numeric value in front of the value that I want to appear on the x-axis (thus controlling the order), but then this value would show up on the chart as well (which I don't want).
How can I control the order that the values appear on the x-axis of my chart??