Graph different markers

A

aspencer27

Using a line graph, I have created a burndown curve and I would like to have
different color markers represent different types of reports. Is there any
way to do this without manually changing the color of each data point? I
would like this graph to update automatically if the type of report ever
changes.

Thanks!
 
A

Andy Pope

Hi,

Maybe you could add additional data series to plot the various coloured
markers. The data for the markers would be related to the curve data via
some form of conditional formula. The extra data series would be markers
only.

If the above is not clear maybe you could post back and explain what the
'different types of report' means.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the graph style I want 4
Overlay line graph points on bar graph 1
Change color of point in series based on date 1
Zero length string on chart 1
Automatic Macro to create 200 graphs 1
evenly spaced markers on log scale 1
How to automate update on weekly reports spreadsheet 0
percentile markers or boxplot on excel scatter graph 1

Top