S ShreyaAnand New Member Nov 7, 2015 #1 I have already extracted the data in Sheet 2 of the attached file but I am unable to plot the graph for the same. I need dates on horizontal axis and line graph of performance & average. Please help! Thanks in advance! Attachments Copy of Sample 1.xlsx 23.4 KB · Views: 6
I have already extracted the data in Sheet 2 of the attached file but I am unable to plot the graph for the same. I need dates on horizontal axis and line graph of performance & average. Please help! Thanks in advance!
bobhc Excel Ninja Nov 7, 2015 #2 Good day and welcome to the forum As per the upload? Attachments Sample 1.xlsx 34.9 KB · Views: 7
V vletm Excel Ninja Nov 7, 2015 #3 .. 2nd version Attachments Copy of Sample 1.xlsx 25.6 KB · Views: 6
S ShreyaAnand New Member Nov 8, 2015 #4 Thank you so much! But the original data is too complex to fit into a graph. Is there anyother way to present it in visual format/graphical format? Whenever I am trying to plot the graph, it displays a text stating "data range is too complex to be displayed." Please help me out! Last edited: Nov 8, 2015
Thank you so much! But the original data is too complex to fit into a graph. Is there anyother way to present it in visual format/graphical format? Whenever I am trying to plot the graph, it displays a text stating "data range is too complex to be displayed." Please help me out!
V vletm Excel Ninja Nov 8, 2015 #5 Could You send that data here? Or at least, how many rows would You like to show? It would be much easier to try to solve Your challenge. Last edited: Nov 8, 2015
Could You send that data here? Or at least, how many rows would You like to show? It would be much easier to try to solve Your challenge.
p45cal Well-Known Member Nov 8, 2015 #6 And to adjust automatically what the chart plots according to the extent of the data: Attachments chandoo26396Sample 1.xlsx 38.8 KB · Views: 14