Creating multiple graphs that exclude missing data

houston182

New Member
Joined
Jun 15, 2017
Messages
1
[FONT=&quot]Hi there,[/FONT]
[FONT=&quot]I’m having some difficulty figuring out how to plot a lot of graphs at the same time and also how to hide values that are blank. When Googling for help, I found that building a macro may be helpful. But I’ve never done anything like that before so I wanted to reach out to see what others may recommend. Please let me know if you have any questions or need more details on my data. Thanks for looking.[/FONT]
[FONT=&quot]I’ll refer to the rows as Variable A and the columns as Outcome X. I’m interested in plotting all the outcomes for each value of Variable A. The problem I’m having is that Variable A has over 1,000 values as Outcome X has over 700 values. My goal is to create a plot with each value of Variable A and show the Outcomes associated with it. This leads to the second issue, which is how to deal with the values that are blank. If I plot the graphs with the blanks, it makes it impossible to read the graphs.[/FONT]
[FONT=&quot]Below, I give a simple overview of what my data looks like. Using the example below, here are the plots I’m interested in making:[/FONT]
[FONT=&quot]A1 with outcome X2 and X4; A2 with outcome X1, X3, and X4; A3 with outcome X3[/FONT]
[FONT=&quot] X1 X2 X3 X4[/FONT]
[FONT=&quot]A1 0 25 0 81[/FONT]
[FONT=&quot]A2 12 0 15 90[/FONT]
[FONT=&quot]A3 0 0 67 0[/FONT]
[FONT=&quot](Notes: My data is simple counts. The cells are blank when there is no value.)[/FONT]
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top