I am using Access 2003. I have a question about charts please:
In a report (not a form), I have a line chart with $ in the vertical axis, Date in the horizontal axis, and 3 values plotted as the data: PlannedCost, ActualCost and TotalCost.
Access made my TotalCost line light yellow and I want to change the color. It seems so simple, but I can't do it.
I can't do it because when looking at my chart in Design view, I only see one line. (I should see 3 lines: PlannedCost, ActualCost and TotalCost, but I don't).
If I could see my 3 lines in Design view, I could right click on the TotalCost line and go to Format Data Series and change the color. My problem is that I can't right click on TotalCost line because it's not displayed.
The weird thing is, when I first created the chart, I had only one value that I called Costs. Later I renamed the value and added 2 more values.
But when I look at the chart in Design view, I see Costs. In Print Preview, it looks fine, but in Design view, it shows me my old chart. It's like the chart hasn't refreshed.
I went in the Code window and clicked Tools, References and checked Microsoft Graph 11.0 Object Library. But that didn't help.
I included two screenshots.
Any ideas?
Thanks,
In a report (not a form), I have a line chart with $ in the vertical axis, Date in the horizontal axis, and 3 values plotted as the data: PlannedCost, ActualCost and TotalCost.
Access made my TotalCost line light yellow and I want to change the color. It seems so simple, but I can't do it.
I can't do it because when looking at my chart in Design view, I only see one line. (I should see 3 lines: PlannedCost, ActualCost and TotalCost, but I don't).
If I could see my 3 lines in Design view, I could right click on the TotalCost line and go to Format Data Series and change the color. My problem is that I can't right click on TotalCost line because it's not displayed.
The weird thing is, when I first created the chart, I had only one value that I called Costs. Later I renamed the value and added 2 more values.
But when I look at the chart in Design view, I see Costs. In Print Preview, it looks fine, but in Design view, it shows me my old chart. It's like the chart hasn't refreshed.
I went in the Code window and clicked Tools, References and checked Microsoft Graph 11.0 Object Library. But that didn't help.
I included two screenshots.
Any ideas?
Thanks,