Hi there
I am having some issues integrating bar graph with scatter graph.
Basically I have a list of individuals with their sales numbers. I tried to show an average line on the graph, which worked out fine.
That said, I want to now show on the same graph, person I select from cell F5 to appear in a different bar graph color. However, I cant seem to change the "graph type" back to a bar graph from scatter graph w/o it distorting the graph? Basically, anytime I have the selected individual, I want it to appear in a different color.
I have attached my sample workbook with how I would like the graph to show the "selected person" in a different bar graph color.
can someone pls help? thanks.
Bookmarks