Time charting.xlsxHi,
I am really stuck up or not aware how to plot a time data with respective names , I want to plot B,D & E column to a chart .. thanks in advance...
Time charting.xlsxHi,
I am really stuck up or not aware how to plot a time data with respective names , I want to plot B,D & E column to a chart .. thanks in advance...
Vipin Oceans
1) Highlighted data D2:E44
2) Inserted "clustered column chart" on new page
3) Right Click = > Select data
3.1) Horizontal (Category) Axis Labels => Edit => C2:C44
3.2) Series one => Edit => D1
3.3) Series two => Edit => E1
4) Select horizontal axis => right click => Format Axis (Axis options) => Interval between labels changed from "automatic" to "1"
That's attached.
(If you want points instead of columns, select whole chart, right click => change chart type => line chart with points, then remove the lines to leave only the points.)
Hi,
May be a way with pivot table and pivot chart
Click on the chart and you are able to filter by Date and Associate Name
You can rearrange your chart with any field
Hope this help
Best regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks