[SOLVED] Chart Data Formatting

Hi, First time poster so here goes. I have a range of cells in which the data changes via a slicer. The data includes numbers, currency and time duration [mm]:ss formats. There is a chart which uses this range to plot the values. Is there a way the chart values can be formatted to adjust to the varying types of data? It defaults to the first type of data selected which is number and will not change which makes the time duration a decimal. I have tried "value from cells" and "linked to source" option in the chart options box to no avail. Thank you Kenny