jeeteshsingh

Hi All,

Greatings!

Is there any possibility of controling excel charts using an excel formula?

I have dynamic values being populated in a table. If the table has two columns filled dynamically, I would need to show a bar graph. If there is only one column, I would need two show a Pie Graph instead of a bar graph.

Now since the values are being populated dynamically, I would need this display of graph to be dynamic.

Can this be controlled by a excel formulae?

Any inputs or ideas would be highly appreciated.

Thanks,
JT

shg

For sure you cannot do this with a formula.

I don't have a clue what the code would look like to change the graph, but would start by recording a macro to make the changes from one to the other, and then go from there.

davecurtis

I do something like this just using a formula. If my imported data has two columns, a bar chart is plotted, and if there is only one column, then a pie chart is plotted. No VBA used at all.
I don't know how to attach a file here, but feel free to email me and I'll attach the file.

Colin Legg

Welcome to the forum davecurtis.

To attach an excel file, please zip it first. When you post, click on the 'Go Advanced' button and then click on the Manage Attachments button in the additonal options section to browse and upload the zip file.

Corresponding solutions via e-mail defeats the purpose of the public forum - I'm sure that lots of XVBT members would like to see your formula-only solution.

HTH,
COlin

davecurtis

Hi,

Thanks for the info Colin.
File attached.
I normally dump my data in the spreadsheet and toggle between scatter, column and box-whisker plots, depending what columns are filled, but I managed it with a pie chart and clustered column chart too.
Uncheck the box to simulate having no data for the second column, and the chart switches to a pie.

Dave

shg

I stand corrected. That's very clever, davecurtis, thank you.

davecurtis

Thanks shg,
Glad to contribute for a change after learning so much from these forums.
Dave