Question Where to view my graph's Chart Wizard ?

[aindoe]

I developed a line chart using chart wizard. Now I have to create another similar line chart but has to change X-axis values but I forgot if I actually developed the graph from query or from table and which fields I dragged to the series and legend etc.. So I need to see the chart wizard of the line chart that I've made so I could trace back.

Is that even possible? because when I double clicked the chart, I still couldn't find the wizard. I tried to re-do the graph based on the SQL and so on but I didn't get the same. There must be something I did, either in the row source or whatnot. I just want to change the x-values to another field.

:banghead:

 

[The_Doc_Man]

If you can identify the chart object, then try Chart.RowSource (which should be either a named query, named table, or SQL string). That should let you at least look at the query you built for it.

In the article in the link below, you will find a question on the subject of Access graphs. The answer includes links to documentation from MS Office regarding the Graph object and how to interact with it.

https://it.toolbox.com/question/msgraphchart8-object-in-ms-access-2010-081914

 

[June7]

The chart wizard only opens when first creating a chart. After that, you can edit the chart directly. Select chart object, look at its RowSource property in the Properties Sheet to see its data source.