How to create a chart with separate values but in the same chart

Hello DanielFlores ,

To display separate lines for each category (DL15, DL25, DL45, DL75, D110), your data should be in a long format. Here's an example:

| Item | Category | Value |

|--------|----------|-------|

| Item A | DL15 | 10 |

| Item A | DL25 | 15 |

| Item A | DL45 | 20 |

| Item A | DL75 | 25 |

1. Import your data

2. If your data is in wide format (each category as a column), use Power Query to transform it:

   - Select the columns DL15 to D110.

   - Click Transform > Unpivot Columns.

   - This will give you a table with Item, Category, and Value.

3. Create a Line Chart:

   - X-axis: Item

   - Y-axis: Value

   - Legend: Category

Have a nice day,

Vivien